topic Re: QlikView: AutoNumber() in QlikView

QlikView: AutoNumber()

marina24 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Can you help me please? Why is the value circled in red equal "2"? It should be "1". How I can do it?

[Table_Temp]:
LOAD ID, STATUS, STATUS_NEXT, DATE_EDIT
FROM
[C:\Users\User\Desktop\test2809.xlsx]
(ooxml, embedded labels);

[Table1]:
NoConcatenate
LOAD ID, STATUS, DATE_EDIT as Date_1, AutoNumber(RowNo(), ID) as Numer_1
Resident Table_Temp
Where STATUS = 'Z047';

[Table2]:
NoConcatenate
LOAD ID, STATUS_NEXT, DATE_EDIT as Date_2, AutoNumber(RowNo(), ID) as Numer_2
Resident Table_Temp
Where STATUS_NEXT = 'Z047';

DROP TABLE Table_Temp;

Re: QlikView: AutoNumber()

sunny_talwar — Mon, 28 Sep 2020 12:58:15 GMT

Try using Peek() instead of AutoNumber() to build this

[Table_Temp]: LOAD ID, STATUS, STATUS_NEXT, DATE_EDIT FROM test2809.xlsx (ooxml, embedded labels); [Table1]: NoConcatenate LOAD ID, STATUS, DATE_EDIT as Date_1, AutoNumber(RowNo(), ID) as Numer_1, If(ID = Peek('ID'), RangeSum(Peek('Numer_1_1'), 1), 1) as Numer_1_1 Resident Table_Temp Where STATUS = 'Z047' Order By ID; [Table2]: NoConcatenate LOAD ID, STATUS_NEXT, DATE_EDIT as Date_2, AutoNumber(RowNo(), ID) as Numer_2, If(ID = Peek('ID'), RangeSum(Peek('Numer_2_2'), 1), 1) as Numer_2_2 Resident Table_Temp Where STATUS_NEXT = 'Z047' Order By ID; DROP TABLE Table_Temp;

Re: QlikView: AutoNumber()

marina24 — Mon, 28 Sep 2020 13:08:13 GMT

Sunny, great thanks for your help!