4 Replies Latest reply: Jul 25, 2011 7:55 AM by stravana RSS

    How can I get next row value in a script?

      How can I get next row value in a script?

      I am new here in the community and need some help. I have QlikView 8.5.
      what is the function of the QlikView-script (not in expression
      ) to get the next row value to a new field?
      I would say the opposite of the Previous ().

       

      Here is my example.

       

      Tab1:

      load * inline

      [Id,Carno,Color

      1,20A,Red

      2,17C,Green

      3,93B,Red

      4,61G,White

      5,48X,Black

      ;

       

      Id

      Carno

      Color

      1

      20A

      Red

      2

      17C

      Green

      3

      93B

      Red

      4

      61G

      White

      5

      48X

      Black

       

      I want to create field NextCarno as below:

      Id

      Carno

      Color

      NextCarno

      1

      20A

      Red

      17C

      2

      17C

      Green

      93B

      3

      93B

      Red

      61G

      4

      61G

      White

      48X

      5

      48X

      Black

      -

       

      Thanks in advance!