topic QlikView Waterfallchart in QlikView

QlikView Waterfallchart

xyz_1011 — Thu, 23 Jun 2022 08:35:53 GMT

Hi all,

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

Thanks a lot in advance!

Re: QlikView Waterfallchart

marcus_sommer — Thu, 23 Jun 2022 12:13:18 GMT

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

Re: QlikView Waterfallchart

xyz_1011 — Thu, 23 Jun 2022 12:22:47 GMT

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)

Re: QlikView Waterfallchart

marcus_sommer — Thu, 23 Jun 2022 12:36:34 GMT

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

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

- Marcus

Re: QlikView Waterfallchart

xyz_1011 — Thu, 23 Jun 2022 13:05:13 GMT

Thanks @marcus_sommer This

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

actually did the job 🙂