Waterfall Chart - Can I use previous value as bar offset

[joshabbott]

I have a waterfall chart that has 13 different bars.  On bar 2 - 13, in order to get the waterfall, I'm storing the value of the previous bar(s) added together.  By the time I get to bar 13, my offset formula is huge.  Is there a Qlikview function or a way I can just set the offset to the value of the previous bar + the offset of the previous bar?  For instance:

Bar 1 - 50

Bar 2 - 5

Bar 3 - 2

Bar 4 - 4

Bar 5 - 2

Bar 6 - 3

Bar 7 - 6

Bar 8 - 1

Bar 9 - 2

Bar 10 - 2

Bar 11 - 1

Bar 12 - 6

Bar 13, the offset is 50 - 5 - 2- 4 - 2 - 3- 6 - 1 - 2 - 2 -1 = 22

It would be much easier if I could take the previous bar offset (23) and subtract the previous bars value (1) = 22.

Thank you for any help!

[danielrozental · Accepted solution]

you can use column() to refer to each bar.

You're expression would look like this column(1) - column(2) - column(3) ... - (column12)

[joshabbott]

That worked perfect for me. Thank you!

[#4]

Hi,

Could you plz also help me to get the attached bar graph.

I've trying it for quite some time now.

Kindly help

Regards