Discussion board where members can get started with QlikView.
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.
load * inline
I want to create field NextCarno as below:
Thanks in advance!
Go to Solution.
Try the following script and it works.
load * inline [
LOAD *,Peek('Carno') as NewField resident Tab1 order by Id desc;
Drop Table Tab1;
Create a field like previousid with a formula id-1.
Use this field with loading the table with resident to join the existing table.
This is the fastest solution i can suggest you but of course there may be more optimised solutions.
Have a look at the attached document.
Thank you very much for the answers. you are the best.