Waterfall Chart

Mon, 04 Jan 2016 08:53:32 GMT

Hello, I'm trying to create income-outcome waterfall chart and i need some help.

I have 1 dimension: (headlines) and 1 expression: Sum (Amount).

And my chart look like this:

I have tried to put expression in the Bar Offset setting, like this:

if ([Exec P&L Heading]<>'incomes', fabs(RangeSum(Above(sum(Amount)),0,RowNo()))-fabs(sum(Amount)), 0)

The blue bar is "incomes" and should start from 0 offset.

But it's not working like it should be, only the red is right, as you can see the green is not touching the bottom of the red

Any help would be appreciated.

Re: Waterfall Chart

Gysbert_Wassenaar — Mon, 04 Jan 2016 17:43:46 GMT

Try: if ([Exec P&L Heading]<>'incomes', fabs(RangeSum(Above(sum(Amount)),1,RowNo()))-fabs(sum(Amount)), 0). The 1 instead of the 0 will prevent using the Amount of the current row in the calculation of the offset too. You want only the sum of all the previous values.

topic Waterfall Chart in QlikView

Waterfall Chart

Re: Waterfall Chart