- QlikView for Developers Cookbook
- Stephen Redmond
- 333字
- 2021-08-13 17:08:23
Creating a Redmond Aged Debt Profile chart
I can't claim that I really created this general type of chart. Someone once said, there is nothing new under the sun. I know that other people have created similar stuff. However, I did create this implementation in QlikView to solve a real business problem for a customer and couldn't find anything exactly like it anywhere else.
This recipe follows on from the previous one (it uses the same data). We are going to extend the straight table to add additional bars to represent the aged debt profile.
Getting ready
Create the straight table from the previous recipe.
How to do it…
Follow these steps to create a Redmond Aged Debt Profile chart:
- Open the properties of the chart and go to the Expressions tab. Right-click on the second expression and select Copy from the menu:
- Right-click in the blank area below the expressions and select Paste. This will create a new expression with the same properties as the copy:
- Repeat the paste operation two more times to create three copies in total.
- Modify the three expressions as follows:
Sum([0-60])/Sum([Total Debt]) Sum([60-180])/Sum([Total Debt]) Sum([180+])/Sum([Total Debt])
- Click on the Gauge Settings buttons for each and choose a different color from the original bar.
- Click on OK when done.
How it works…
The first column is a bar chart representing the vertical distribution of the total debt for each country. In the three following period columns, we divide each period value by the total debt for that country to get the ratio—the horizontal distribution of that country's debt across the periods. This allows the user to quickly scan down the chart and see which countries have the highest percentage debt in each period.
There's more…
There a many more situations where this can be used. Anywhere that you might consider using a stacked bar chart, consider using a Redmond instead.
See also
- The Creating a modified bullet chart in a straight table recipe
- 中國新股民必讀手冊（2015年最新版）
- 金融科技（FinTech）發展的國際經驗和中國政策取向（中國金融四十人論壇書系）
- 金融保險集團內部審計創新與實踐
- 讓財報說話：世界500強CFO帶你輕松讀財報（鮮讀版）
- 中國特色社會主義國家審計制度研究
- Metabase Up and Running
- Learning Informatica PowerCenter 9.x
- Microsoft Dynamics CRM 2011 Scripting Cookbook
- OAuth 2.0 Identity and Access Management Patterns
- 審計全流程實操從入門到精通
- Getting Started with Citrix VDI-in-a-Box
- PMP備考寶典：路晨帶你去通關
- Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）
- 統計原理與實務
- INSTANT IBM Lotus Notes 8.5.3 How-to