topic Re: Waterfall Model in Qlikview in QlikView

Waterfall Model in Qlikview

parul_mehta — Thu, 18 May 2017 13:33:52 GMT

I require to create the waterfall chart in the attached screenshot, going from the highest until lowest value

Please provide inputs

prieper — Thu, 18 May 2017 13:37:31 GMT

parul_mehta — Thu, 18 May 2017 13:44:03 GMT

Peter I require similar to the screenshot attached

prieper — Thu, 18 May 2017 14:13:36 GMT

What is different than in the above guide?

please find an example attached

Peter

parul_mehta — Thu, 18 May 2017 14:34:52 GMT

1) The first bar is ending at 3, the next should start at 3 and not 0.

the second ends at 7, the third should start at 7

2) How to change the complete background color to black

3) How to display only upto 2 decimal places in values on data points in

prieper — Thu, 18 May 2017 14:47:12 GMT

why is the first bar ending at 3?

Have you read the above link?

Other settings from Numbers, Colours, Axes etc.

Anonymous — Thu, 18 May 2017 14:49:41 GMT

Hi Peter,

You want the exact chart, please send sample data and we will help.

parul_mehta — Fri, 19 May 2017 03:30:58 GMT

Wilson,

PFA screenshot of the chart that I require.( Waterfall.jpg)

I have been able to create until this level ( Waterfal1.jpg)

Pending issues are:

Pending changes:

Background color to be changed to black as in the sample shared.
Value on data points to be changed to 2 decimals, expression to be kept at 0 decimals. ( currently both are getting picked as 2 decimals ) if I change the number format. I require 2 decimals for data points , and 0 deciamls for the x axis values as in waterfall.jpg
Total expression to be added ( total is the sum of all values, and should start from 0 )
Display $ value on data points only ( like in waterfall.jpg )

Data is stored in waterfall.xls, which needs to be displayed.

waterfall.qvw attached , which i have been able to create.

4 points mentioned above need to be implemented as well. ( Same as waterfall.jpg )