topic give sequence number in script in QlikView

give sequence number in script

markgraham123 — Thu, 10 Nov 2016 16:54:32 GMT

Hi all,

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.

Data:

O/P:

Any help is highly appreciated.

johnw — Thu, 10 Nov 2016 17:01:02 GMT

Assuming you're loading from your real data source in ID order:

LOAD *
,if(ID=previous(ID),peek(Seq)+1,1) as Seq

markgraham123 — Thu, 10 Nov 2016 17:06:38 GMT

That was perfect John!!

Thanks:)

antoniotiman — Thu, 10 Nov 2016 17:10:22 GMT

May be

LOAD *,Autonumber(RowNo(),ID) as Sequence

Regards,

Antonio

johnw — Thu, 10 Nov 2016 17:14:23 GMT

Oooh, even better! Simpler, and not sensitive to the order of the data!