Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

parul_mehta
Contributor

Waterfall Model in Qlikview

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

Please provide inputs

7 Replies
prieper
Honored Contributor II

Re: Waterfall Model in Qlikview

parul_mehta
Contributor

Re: Waterfall Model in Qlikview

Peter I require similar to the screenshot attached

prieper
Honored Contributor II

Re: Waterfall Model in Qlikview

What is different than in the above guide?

please find an example attached

Peter

parul_mehta
Contributor

Re: Waterfall Model in Qlikview

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
Honored Contributor II

Re: Waterfall Model in Qlikview

why is the first bar ending at 3?

Have you read the above link?

Other settings from Numbers, Colours, Axes etc.

Highlighted
willbleksem
New Contributor III

Re: Waterfall Model in Qlikview

Hi Peter,

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

parul_mehta
Contributor

Re: Waterfall Model in Qlikview

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:

 

  1. Background color to be changed to black as in the sample shared.
  2. 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
  3. Total expression to be added ( total is the sum of all values, and should start from 0 )
  4. 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 )