Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz_1011
Partner - Creator
Partner - Creator

QlikView Waterfallchart

Hi all,

can anyone help me turning the bar chart in the attached QVW into a waterfall chart ? 

Thanks a lot in advance!

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

In such case you may need an interrecord-function like above() for the offset, maybe something like:

rangesum(above(sum(Sales), 0, rowno()))

- Marcus

View solution in original post

4 Replies
marcus_sommer

The magic to create a waterfall-chart is to calculate an appropriate offset-value within the attribute-expressions. More details could you find here: Waterfall Chart in QlikView - Qlik Community - 1481353

- Marcus

xyz_1011
Partner - Creator
Partner - Creator
Author

Thanks @marcus_sommer I get the idea with using multiple expressions where expression #2 uses expression #1 as bar offset....but how do i do this with just one expression (i.e. sales by month)

marcus_sommer

In such case you may need an interrecord-function like above() for the offset, maybe something like:

rangesum(above(sum(Sales), 0, rowno()))

- Marcus

xyz_1011
Partner - Creator
Partner - Creator
Author

Thanks @marcus_sommer  This

rangesum(above(sum(Amount), 1, rowno()))

actually did the job 🙂