enumerate rows in Qlik View Script

anwarbham — Sat, 16 Nov 2024 00:39:48 GMT

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

Re: enumerate rows in Qlik View Script

jochem_zw — Sat, 16 May 2020 15:48:26 GMT

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

topic Re: enumerate rows in Qlik View Script in QlikView

enumerate rows in Qlik View Script

Re: enumerate rows in Qlik View Script