3 Replies Latest reply: May 18, 2012 7:51 AM by Lav Jain RSS

    Waterfall Chart - Can I use previous value as bar offset

    Josh Abbott

      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!