Discussion Board for collaboration on QlikView Scripting.
I have this problem.
I have a logical table in my application.
I want to generate Line_Number(seqNo) for each distinct value of Field "Doc_No".
So for example I want the Line_Number be generated like this:
Thanks in advance,
Go to Solution.
check the attach file
hope it helps you
Thanks! Was looking for this too!
Liron, I am unable to open the TEST.qvw file since I am running personal edition and I am out of recovery keys.
Anyhow hoping that you could post and explain your script here.
Any assistance would be appriciated
Try like this
Load *, if(Previous(Doc_No)=Doc_No,numsum(peek('Line_Number'),1),1) As Line_Number from tableName;
Hope it helps