topic Return same or similar records in App Development

Return same or similar records

didierodayo — Mon, 09 May 2016 03:22:52 GMT

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_ID	MobileNM
1	99784561
2	77542168
3	68542879
4	11789562
5	54789562
6	33535565
7	74145428
8	94852630
9	25893754
10	99784562
11	99784561

Re: Return same or similar records

shwetagupta — Mon, 09 May 2016 17:17:38 GMT

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.

Re: Return same or similar records

didierodayo — Mon, 09 May 2016 18:27:34 GMT

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?

Re: Return same or similar records

shwetagupta — Tue, 10 May 2016 08:21:02 GMT

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.