Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

Re: Checking for Duplicate Values in a Field

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]