19 Replies Latest reply: Oct 24, 2012 6:14 AM by Christophe Brault RSS

    Getting the previous row and calculate.

      Hello and Good Day, I'm currently new in QlikView and I say this is one powerful B.I Tool.

      I'm still learning and I need to solve something..

       

      I have a table

       

       

      DIDValueValue1
      D112000 0
      D213000 1000
      D322000 0
      D421500 -500
      D52500-1000
      D631000..

       

       

      I need to compute for Value1 depending on the ID.

      The computation is d2-d1, d4-d3, d5-d4

       

      I find it hard to explain, but I just need to compute for Value1 depending on the next Value.

       

      Thank you and Good Day.

       

      P.S This is for scripting Thank you.