QlikView: AutoNumber()

[marina24]

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;

[sunny_talwar · Accepted solution]

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;

[marina24]

Sunny, great thanks for your help!