How to add a sequencenumber (based on date) within... - Qlik Community

Report Inappropriate Content · ‎2010-04-17

Hi,

I need to create %2TalSeq:

Within the same value of %2Tal , the numbering has to restart at 1.

Thanks

Paul

Oleg_Troyansky · ‎2010-04-17

If you need to do it in the script, you can use functions previous() and peek() to compare the value of the Items and assign the Counter accordingly.

Something like this:


load
 Item,
 Date,
 if(previous(Item) <> Item, 1, peek(Counter) + 1) as Counter
resident
 Tab1
Order By
 Item, Date
;

Report Inappropriate Content · ‎2010-04-18

Oleg,

Thank you.

Paul

How to add a sequencenumber (based on date) within a same articlenumber