Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

If statement to find "New" "Repitition" and "Not Involved" Ids

Hi All,

I have to create a flag column (D column in the attached excel)  in script with the below dataset.

two conditions if value is >0

1) Same ids with first date should be New

2) Same ids with other dates are Repitition

if value =0 then Not Involved.

IdDateValueFlag
11/14/20200Not Involved
11/16/20201New
11/19/20203Repitition
12/25/20206Repitition
13/29/20200Not Involved
21/13/20204New
21/16/20206Repitition
22/18/20209Repitition
22/21/20200Not Involved
24/23/20200Not Involved
26/6/20206Repitition

 

Best Regards,

Siva

0 Replies