Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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]