- QlikView for Developers Cookbook
- Stephen Redmond
- 318字
- 2021-08-13 17:08:23
Creating a bar chart in a straight table
Straight tables are great for displaying numbers. Bar charts are great for showing the information visually. A great thing that you can do in QlikView is combine both—using linear gauges.
Getting ready
Load the following script:
LOAD * INLINE [ Country, Total Debt, 0-60, 60-180, 180+ USA, 152, 123, 23, 6 Canada, 250, 100, 100, 50 UK, 170, 170, 0, 0 Germany, 190, 0, 0, 190 Japan, 90, 15, 25, 50 France, 225, 77, 75, 73 ];
How to do it…
Use these steps to create a straight table containing a bar chart:
- Create a new straight table. Set the dimension to be
Country
. Add two expressions:Sum([Total Debt]) Sum([Total Debt]) / Max(Total Aggr(Sum([Total Debt]), Country))
- Set the Total Mode property of the second expression to No Totals.
- Change the Representation property of the second expression to Linear Gauge.
- Click on the Gauge Settings button and enter the following settings for the gauge:
- There should be two segments already there. Remove Segment 2, leaving only 1.
- Set the color of the segment to an appropriate color. Pastels work well here.
- Click on OK. Click on Finish to close the chart wizard.
How it works…
The AGGR expression returns the maximum value across all the countries. In this example, 250 from Canada. If we then divide the total debt for each country by this maximum value, we will get a ratio with a maximum value of 1. This is exactly what we need to create the bar chart with the linear gauge.
There's more…
This technique can be utilized anywhere that you need to create a bar chart in a table such as this. The added visual can really bring the numbers to light.
See also
- The Creating a modified bullet chart in a straight table recipe
- The Creating a Redmond Aged Debt Profile chart recipe
推薦閱讀
- Magento 2 Cookbook
- 金融保險集團(tuán)內(nèi)部審計(jì)創(chuàng)新與實(shí)踐
- Citrix? XenMobile? Mobile Device Management
- 注冊會計(jì)師全國統(tǒng)一考試專用教材:審計(jì)
- EViews10.0的應(yīng)用與計(jì)量分析
- Securing Hadoop
- Salesforce Essentials for Administrators
- Getting Started with Citrix VDI-in-a-Box
- Microsoft Dynamics NAV
- vSphere Design Best Practices
- 風(fēng)險導(dǎo)向?qū)徲?jì)準(zhǔn)則實(shí)施效果研究
- Programming Microsoft Dynamics NAV(Fifth Edition)
- 內(nèi)審兵法
- Oracle E-Business Suite Financials R12:A Functionality Guide
- 看穿一切數(shù)字的統(tǒng)計(jì)學(xué)