Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anwarbham
Contributor III
Contributor III

enumerate rows in Qlik View Script

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_ContactsActivity_Entry_Type
1DaveA22-Jan-202025Full Blank Week-Day with Contacts
2DaveA22-Jan-202025ToT Entry
1RobB22-Jan-202020ToT Entry
1JanC23-Jan-202019Full Blank Week-Day with Contacts
1ErikA23-Jan-202018Full Blank Week-Day with Contacts
2ErikA23-Jan-202018ToT Entry

 

Any Help Appreeciated

 

Labels (2)
1 Solution

Accepted Solutions
jochem_zw
Partner
Partner

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

View solution in original post

1 Reply
jochem_zw
Partner
Partner

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

View solution in original post