- QlikView for Developers Cookbook
- Stephen Redmond
- 398字
- 2021-08-13 17:08:22
Creating a modified bullet chart in a straight table
The main components of a bullet chart (from Stephen Few's perceptualedge.com) are as follows:
- A text label
- A quantitative scale along a single linear axis
- The featured measure
- One or two comparative measures (optional)
- From two to five ranges along the quantitative scale to declare the featured measure's qualitative state (optional)
The "traditional" approach is to have bar representing the feature measure and a line representing the comparative measure. However, as long as we have two separate representations, the bar is not absolutely necessary.
In this recipe we will present a modified bullet chart using an inline linear gauge in a straight table. This allows users to view the results across all the values in a dimension.
Getting ready
Load the following script:
LOAD * INLINE [
Country, Sales, Target
USA, 1000, 1100
UK, 800, 1000
Germany, 800, 700
Japan, 1000, 1000
];
How to do it…
Follow these steps to create a straight table with a modified bullet chart:
- Create a new straight table. Set the dimension to be
Country. Add three expressions:Sum(Sales) Sum(Target) Sum(Sales)/Sum(Target)
- Change the representation of the third expression to Linear Gauge.
- Click on the Gauge Settings button and enter the following settings for the gauge:
- Set the color of both segments to be the same. I usually go for a light gray.
- Click on OK. Click on Finish to close the chart wizard.
- The modified bullet chart should appear in the straight table.
How it works…
Because we are calculating a percentage here, it is valid to use the same gauge for each dimension (which would not have been valid in a straight table for absolute values).
By using two segments in the linear gauge, the border between them, which we have set to 1 = 100%, presents as a line. This is our target value. The needle of the gauge displays the percentage of sales versus that target.
The user can quickly scan down the table to see the better performing territories. This field is also sortable.
There's more…
Using linear gauges in straight tables can be a great way of visually representing data. It is worth playing around with.
See also
- The Creating a Stephen Few bullet chart recipe
- The Creating a bar chart in a straight table recipe
- The Creating a Redmond Aged Debt Profile chart recipe
- 中國國民經濟核算體系修訂問題研究
- 汪博士詳解PMP?模擬題（第4版）
- Business Intelligence with MicroStrategy Cookbook
- Metabase Up and Running
- 基本有用的計量經濟學
- 審計實務案例與實訓教程
- 新編統計學
- 成功通過PMP（第3版）
- 企業并購審查中的相關市場界定：理論與案例
- Getting Started with Microsoft Lync Server 2013
- 企業內部審計全流程指南
- Implementing VMware Horizon 7.7
- 傳習集2
- Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）
- 統計學理論前沿（谷臻小簡·AI導讀版）