enumerate rows in Qlik View Script

[anwarbham]

Hi I have a table im loading from  A QVD 

that i want to enumerate the rows

basicly add the Row No based on if %User_Key has another row for the same date via  %Calendar_Key 

i have tried the load below but it does not give me the resulkts intended

Load
AutoNumber(RecNo(),[%User_Key]) as rowNo,
[%User_Key] as User,
[%Calendar_Key] as Udate,
Activity_Entry_Type  ,
_Contacts
Resident F_TimeInField_tmp2;

Row No	%User_Key	%Calendar_Key	_Contacts	Activity_Entry_Type
1	DaveA	22-Jan-2020	25	Full Blank Week-Day with Contacts
2	DaveA	22-Jan-2020	25	ToT Entry
1	RobB	22-Jan-2020	20	ToT Entry
1	JanC	23-Jan-2020	19	Full Blank Week-Day with Contacts
1	ErikA	23-Jan-2020	18	Full Blank Week-Day with Contacts
2	ErikA	23-Jan-2020	18	ToT Entry

Any Help Appreeciated

[jochem_zw · Accepted solution]

Try AutoNumber([%User_Key], %Calendar_Key ) as rowNo,