Tuesday 5 April 2016

QlikView Charts Part 3 Redmond Aged Debt Profile and Waterfall Chart

QlikView Charts Part 3 Redmond Aged Debt Profile and Waterfall Chart

How to create Redmond Aged Debt Profile chart and Waterfall Chart in QlikView

Redmond Aged Debt Profile chart
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.


Waterfall Chart:-

A waterfall chart is a type of bar chart used to show a whole value and the breakdown of that value into other subvalues, all in one chart. We can implement it in QlikView using the Bar Offset option.
In this example, we are going to demonstrate the chart showing a profit and loss breakdown.


Above Charts creations are covered in below video.



Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel