Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Highlighted
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.

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 )