Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner
Partner

Return same or similar records

Hi Guys,

I am working on a Fraud detection project and need help with the following.

I am trying to identify SAME or SIMILAR records from the same table. For example if on the employee table we have 2 different employee with the same account number , or the same home phone or same postal code. I typed a sample table below.

I need some suggestions on the type of Qlik sense queries I could use for this purpose.

Many Thanks

   

Patient_IDMobileNM
199784561
277542168
368542879
411789562
554789562
633535565
774145428
894852630
925893754
1099784562
1199784561
1 Solution

Accepted Solutions
shwetagupta
Partner
Partner

Hi Didier,

Though I am pretty new to Qlik sense but you can use pivot tables for finding the Same values. Attaching image of the pivot table on the data you have provided. !

I hope this will be of some help.

Pivot.png

View solution in original post

3 Replies
shwetagupta
Partner
Partner

Hi Didier,

Though I am pretty new to Qlik sense but you can use pivot tables for finding the Same values. Attaching image of the pivot table on the data you have provided. !

I hope this will be of some help.

Pivot.png

View solution in original post

didierodayo
Partner
Partner
Author

Thanks Gupta, I will stick to pivot table then but my challenge would be to write expressions that will identify similar records  (where first 4 digits are the same ). Do you have any ideas?

shwetagupta
Partner
Partner

Hi Didier,

You can try wildmatch / Match by providing the length to compare. for finding similar data.

I havent used it for whole table but I have used it for some particular data.