Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

billuran
Contributor

Look Up value based on first occurrence of record

Hello, Have a table PersonID, Event, Date. I currently have in the script to label event based on the beginning of value in load script.

if(left(event,4)='9921','LABELX','') as VISITTYPE

works great.

However If PersonID does not have a 9921 label then I want to label the first event that starts with 9920 for each PersonID. If it shows up a 2nd etc.. time don't label for that PersonID.

The table is already in chronological  order.

Thanks,

Bill

Community Browser