Qlik Sense Waterfall Chart (No Extension)

    Nowadays, one of the most popular charts used in Finance is a Waterfall chart. Waterfall charts are most suitable in showing how we have arrived at a net value. Because it can clearly break down the cumulative effect of positive and negative contributions. This is very helpful for many different scenarios, from visualizing financial statements to navigating data about population, births and deaths.

     

    It is easy to come up with a waterfall chart in Qlik View. Unfortunately we don’t have a direct way of achieving it in Qlik Sense. Because we don’t have an offset option in bar chart. Anyway it is not impossible to make a waterfall chart in Qlik Sense.  There are few workarounds for this. Here I am giving out one way of achieving it.

     

    Please go through the attached QVF files.

    1. Static Waterfall (This will be easy to follow.  See this first)
    2. Dynamic Waterfall (Practical approach)

     

    While going through this, newbies can also understand Above(), Rangesum(), Rangemin() functions.

    Please give it some time to understand how we have achieved it.  To have a better understanding I have split the expression in a flat table for Static Waterfall. Frontend wise it is same for Static and dynamic waterfall. 

     

    Please leave your comments below.