Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
santhana
Contributor III
Contributor III

Checking for Duplicate Values in a Field

Hello Friends

 

I have a field - Mobile Number.  In case a mobile number  in current quarter is also available upto the end of previous quarter I want to mark them as Duplicate.

Kindly help to achieve above result.

 

Thanks & Regards

Santhana

1 Reply
mrtinsjoao
Contributor III
Contributor III

Great day
You can count if exists reincidence with this code in script

IF(PEEK([x])=[x],PEEK([cont x])+1,0) as [cont verify x]