Qlik Community

Qlik Sense App Development

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

didierodayo
Contributor III

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
Contributor

Re: Return same or similar records

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

3 Replies
shwetagupta
Contributor

Re: Return same or similar records

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

didierodayo
Contributor III

Re: Return same or similar records

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
Contributor

Re: Return same or similar records

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.

Community Browser