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

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

Sat, 17 Apr 2010 15:30:08 GMT

Hi,

I need to create %2TalSeq:

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

Thanks

Paul

Oleg_Troyansky — Sat, 17 Apr 2010 16:23:39 GMT

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
;

Sun, 18 Apr 2010 20:08:57 GMT

Oleg,

Thank you.

Paul