topic Re: Waterfall Chart - Can I use previous value as bar offset in QlikView

Waterfall Chart - Can I use previous value as bar offset

joshabbott — Tue, 02 Aug 2011 17:01:18 GMT

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!

Waterfall Chart - Can I use previous value as bar offset

danielrozental — Tue, 02 Aug 2011 17:04:23 GMT

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

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

Waterfall Chart - Can I use previous value as bar offset

joshabbott — Tue, 02 Aug 2011 18:33:06 GMT

That worked perfect for me. Thank you!

Re: Waterfall Chart - Can I use previous value as bar offset

Fri, 18 May 2012 11:50:46 GMT

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