Autonumber

[dmpilars]

Hi, 

Thanks for your help. I need to do this in a ID column. Autonumer column for Project and Time, I need that autonumber start again in 1 for each group of projects

ID	TIME	PROJECT	SUM
1	1 FEB	AAA	1224
2	1 MAR	AAA	9876
3	1 APR	AAA	7654
1	1 FEB	BBB	5432
2	1 SEP	BBB	1234
1	1 MAY	CCC	4444
2	1 JUN	CCC	1234
3	1 JUL	CCC	3456
4	1 AUG	CCC	5634

Autonumber(Proyect&Time) not works, create a consecutive but not start again in 1 for each project.

Thanks a lot.

[Sarchiz]

if(PROJECT=previous(PROJECT),rangesum(Peek(ID),1),1)as ID

-- also don t forget to order by  PROJECT, TIME,SUM

[vinieme12 · Accepted solution]

You just need to add the another parameter which is available with the autonumber() function , as below 

Autonumber(Project&Time,Project) as ID 

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterFunct...

[dmpilars]

Vineeth

Thank you very much, I was really missing a small detail that you kindly helped me to discover!!!!

[dmpilars]

Thank you very much for your help, Vineeth gave us a slightly more efficient solution in terms of resources, however, yours works too, thank you very much.