QlikView Waterfallchart

[xyz_1011]

Hi all,

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

Thanks a lot in advance!

[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]

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 · Accepted solution]

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]

Thanks @marcus_sommer  This

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

actually did the job 🙂