- 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
- Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c
- Mastering System Center Configuration Manager
- 中國特色社會主義國家審計制度研究
- 博弈論及其在經濟管理中的應用
- Microsoft Dynamics CRM 2011 Scripting Cookbook
- 審計實務案例與實訓教程
- 陜西國家統計調查專題研究集萃（2006—2015）
- 2016年度注冊會計師全國統一考試專用輔導教材（圖解版）：審計
- 振蕩指標MACD：波段操作精解（升級版）
- 新編統計學
- 風險導向審計準則實施效果研究
- Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）
- 審計定價問題研究
- 審計學
- 中國重點經濟領域統計分析