topic autonumbering in QlikView

autonumbering

Thu, 06 Aug 2009 23:19:27 GMT

Dear all,

I need your advice about the following problem:
I have 3 dimensions in a pivot table (Country, DelivDate,DelivMaterial) and I need to add a field for autonumbering related only to the first two dimensions(Country, DelivDate).
At each change with the 'Country' the numbering should start with '1'and at each change
of 'DelivDate' the numbering should increase with '1'.
I thought about using Ronum(), but it doesn't work with 3 dimensions, only when there are two.

Kalin

autonumbering

biester — Tue, 18 Aug 2009 01:06:40 GMT

Hi Kalin,

just to be sure I'm getting you right an example (in brackets the autonumbered field):

Belgium 1.7.09 (1) Material A
Belgium 2.7.09 (2) Material B
Austria 5.7.09 (1) Material ...
Austria 6.7.09 (2) ......
Austria 7.7.09 (3) ....
Germany 1.7.09 (1)

Have you already tried with the peek() function - I think it would be better to do this in the script (also because of better performance)? Perhaps the purpose of your demand would give a better insight.

Rgds

Joachim

autonumbering

Mon, 24 Aug 2009 16:20:58 GMT

Biester, thank you very much about answering and helping me.

To be honest it took me so long to answer, because I was experimenting with different approaches the PEEK function.

I've got what I needed with the PEEK, implementing it in a IF condition:

LOAD

PRODUCT,

DATE,

QTY,

If(Peek(Product)<>Product,1,Peek(Numbering)+1)

Group by Product, Date

Resident TRANSACTIONS;

Drop TRANSACTIONS;

Have a nice week-end!

Kalin

AW:Re: autonumbering

biester — Mon, 24 Aug 2009 17:29:06 GMT

Hi Kalin,

as I see your experimenting suceeded. Your script is just the way I had in mind.

Rgds,
Joachim

P.S.: Weekend's already over now, unfortunately ;-(