Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can anyone help me turning the bar chart in the attached QVW into a waterfall chart ?
Thanks a lot in advance!
In such case you may need an interrecord-function like above() for the offset, maybe something like:
rangesum(above(sum(Sales), 0, rowno()))
- Marcus
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
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)
In such case you may need an interrecord-function like above() for the offset, maybe something like:
rangesum(above(sum(Sales), 0, rowno()))
- Marcus