Qlikview Waterfall Tutorial

“A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air.

The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. Usually the initial and the final values are represented by whole columns, while the intermediate values are denoted by floating columns. The columns are color-coded for distinguishing between positive and negative values.” (Wikipedia, 2015)

https://www.aploris.com/support/documentation/area-waterfall-and-marimekko-chart

Considerations:

1.    Each bar will have a different expression.

2.    The chart can be created without adding any dimensions.

3.    Have an idea as to what you want to show.

4.    Have all the data you need.

Steps:

1.    Open up Qlikview.

2.    Go to the tab that you are working on.

3.    Right click on where you would like to add the chart->New Sheet Object->Chart.

4.    Choose Bar Graph. Click finish.

5.    Go to the chart, right click and choose properties.

6.    Go to expressions.

 

7.  Add all the expressions that you want to use but make sure the first expression will be the tallest bar. In most cases, it is the overall total of all the expressions. So basically, all the other expressions should add up to the tallest bar. 

      8. Once you have all your expressions and ready to show, Do the following: 

                  a.    Expand the second expression.

b.    Go to the Bar offset.

 

  c.    In the definition, you will subtract the overall expression (First expression) from the second one (expr1 – expr2).

d.    Expand the third expression.

e.    Go to the Bar offset.

f.    In the definition, you will subtract the overall expression (First expression) from the second one plus the third one. So you will have something like, expr1 – (expr2 + expr3). You will do the same for all other expressions.

g.    The last expression is left without changing the bar offset. (This can be the expression with the lowest total).

9.  To style the chart, just go to the properties of the chart and change them as you deem necessary. By the end of this tutorial, you should have something like the below:

Reference

. 2016. . [ONLINE] Available at: http://source.entelect.co.za/creating-a-waterfall-effect-in-qlikview. [Accessed 11 March 2016].