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