Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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