Discussion Board for collaboration on QlikView Scripting.
I'm trying to give sequence to the value of ID. Grouped by ID, for every Value i would like to give a sequence number - 1,2,3
No specific order. Just a sequence number for every instance grouped by ID.
Any help is highly appreciated.
Go to Solution.
Assuming you're loading from your real data source in ID order:
LOAD * ,if(ID=previous(ID),peek(Seq)+1,1) as Seq
That was perfect John!!
LOAD *,Autonumber(RowNo(),ID) as Sequence
Oooh, even better! Simpler, and not sensitive to the order of the data!