Stephen Few designed the bullet chart as a replacement for a traditional gauge.
A traditional gauge takes up a large amount of space to encode, usually, only one value. A bullet chart is linear and can encode more than one value.
The main components of a bullet chart (from Stephen Few's perceptualedge.com) are as follows:
There is no native bullet chart in QlikView. However, we can create one by combining a couple of objects.
Items 1, 2, 4, and 5 can be achieved with a linear gauge chart. The bar, item 3, can then be overlaid using a separate and transparent bar chart.
Load the following script:
LOAD * INLINE [
Country, Sales, Target
USA, 1000, 1100
UK, 800, 1000
Germany, 800, 700
Japan, 1000, 1000
];Perform the following steps to create a Stephen Few bullet chart:
Add a new gauge chart. You should add a title and enter text for Title in chart. Click on Next.
There is no dimension in this chart. Click on Next.
Enter the following expression:
Sum(Target)
Click on Next.
There is no sorting (because there is no dimension), so click on Next.
On the Style tab, select a linear gauge and set the orientation to horizontal. Click on Next.
There are a few changes needed in the Presentation tab:
Gauge Settings, Max
Sum(Target) * 1.2Indicator, Mode
Show NeedleIndicator, Style
LineShow Scale,
Show Labels on Every
1Autowidth Segments
Off
Hide Segment Boundaries
On
Hide Gauge Outlines
On
There should be two segments by default, add a third segment by clicking on the Add button. The settings for each segment are as follows:
Segment 1, Lower Bound
0.0Segment 2, Lower Bound
Sum(Target) * 0.5Segment 3, Lower Bound
Sum(Target) * 0.9Apply appropriate colors for each segment (for example, RAG or Dark/Medium/Light gray).
Click on Finish.
Most of the bullet chart elements are now in place. In fact, this type of linear chart may be enough for some uses. Now we need to add the bar chart.
Add a new bar chart. Don't worry about the title (it will be hidden). Turn off Show Title in Chart. Click on Next.
There is no dimension in this chart either. Click on Next.
Add the following expression:
Sum(Sales)
Click on Next.
There is no sort (as there is no dimension). Click on Next.
Select a plain bar type. The orientation should be horizontal. Leave the style at the default of Minimal. Click on Next.
Set the following axis settings:
Hide Axis
On
Static Max
On
Static Max Expression
Sum(Target)*1.2Click on Next.
On the Color tab, set Transparency to 100%. Set the first color to a dark color. Click on Next.
Continue to click on Next until you get to the Layout tab. Set the shadow to No Shadow and the border width to
0. Set the Layer to Top. Click on Next.Turn off the Show Caption option. Click on Finish.
Position the bar chart over the gauge so that the scales match (Ctrl + arrow keys are useful here). The bullet chart is created.
By matching the Static Max setting of the bar and the gauge (to the sum of target * 1.2), we ensure that the two charts will always size the same. The 1.2 factor makes the area beyond the target point of 20 percent of the length of the area before it. This might need to be adjusted for different implementations.
It is also crucial to ensure that the layer setting of the bar chart is at least one above the layer of the gauge chart. The default layer (on the Layout tab) for charts is Normal so, in that situation, you should change the bar chart's layer to Top. Otherwise, use the Custom option to set the layers.
Using techniques such as this to combine multiple QlikView objects can help us create many other visualizations.