topic Re: auto number use cases clarification; in QlikView

auto number use cases clarification;

shanmathytitu — Mon, 26 Jan 2026 18:19:17 GMT

t2:

Load *,

Pnumber,

Prodnamecode,

autonumber(Pnumber & Prodnamecode )as keynum

from t1

order by date,

t3:

Load *,

AutoNumber(RecNo(),Autonumber(Autonumber(AutoNumber(keynum)))) as keynum1

resident t2;

t4:

Load *

from t3

where keynum1=1

order by date;

drop table t1,t2,t3;

What is the where clause restriction here and use of autonumber here. can you explain more in detail

Re: auto number use cases clarification;

rwunderlich — Thu, 07 Jul 2022 16:59:19 GMT

You have a nested AutoNumber() here that does not make sense to me, Can you explain what your objective is?

-Rob

Re: auto number use cases clarification;

shanmathytitu — Fri, 08 Jul 2022 13:55:16 GMT

I am looking into one dashboard which has this code. I am trying to understand what was the motive to restrict only keynum1=1. Is that something for duplicate removal. I am not sure on that. i need someone help in understanding this multiple autonumber and its restriction.

Re: auto number use cases clarification;

marcus_sommer — Mon, 11 Jul 2022 15:49:17 GMT

Like Rob already mentioned it makes no sense to nest autonumber() multiple times and hints more for any mistakes by designing this application. The origin purpose is hard to guess - the most likely seems to be to create a counter for the frequency of the occurrence of the field-combination of Pnumber & Prodnamecode and only the first one remains an the others are removed from the where-clause.

You may just comment the condition to see the difference within the loaded data between both approaches ...

- Marcus

Re: auto number use cases clarification;

rwunderlich — Mon, 11 Jul 2022 17:55:33 GMT

If you are trying to restrict the rows to the first occurrence of Pnumber & Prodnamecode then you can simply do :

T1:
Load
*
Where not Exists(keynum, keynum);
Load
*,
Hash128(Pnumber, Prodnamecode )as keynum
from ...;

Drop Field keynum;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com