Identify common mobile number

[Sunil645454]

I have mobile numbers and one number can have multiple reference id's so the requirement is when I select one reference id then table should show all reference id with respect to mobile number means mobile number associated with selected reference id. so want to see all reference id with common mobile number after selection of one reference id through filter , example Data:
Load*
Inline [
Reference_ID,Mobile_Number
Ref12345,9999999999
Ref56789,9999999999
Ref98765,8888888888
];

so when select Ref12345 in filter then my table should show result Ref56789,9999999999

[Sunil645454]

Ahh, I was applying other methods thats why and forgot to remove it,

Thanks rubenmarin

[Sunil645454]

If you get a change please look into it as well -https://community.qlik.com/t5/Data-Quality/Use-measures-as-name-as-dimension-in-filters/m-p/2539952#M4342

[rubenmarin]

I can't right now. I hope to remember when I have some spare time.

I took a look and it's hard to follow, can you prepare a sample qvf that explains the requirements with some dummy data and the expected reult?

[Sunil645454]

Okay, I thought having mobile number issue resolved will resolve my other column but it is not working as I thought please check the screen shot I added email as well and it is giving correct result but mobile number should be there and vice versa, I am going to add the 3 column as well 

Load*
Inline [
Ref_ID,Mobile_Number,Email
Ref12345,9999999999,abc@gmail.com
Ref56789,9999999999,xyz@gmail
Ref98765,8888888888,abc@gmail.com
Ref98123,7777777777,mnc@gmail.com
];

[rubenmarin · Accepted solution]

Hi, If you want to show all data when any of the columns is duplicated you can use:

=Only({<Mobile_Number=P(Mobile_Number),Ref_ID=>+<Email=P(Email), Ref_ID=>} Mobile_Number)

=Only({<Mobile_Number=P(Mobile_Number),Ref_ID=>+<Email=P(Email), Ref_ID=>} Email)

[Sunil645454]

Thanks its working, can you please look into my other issue https://community.qlik.com/t5/Data-Quality/Use-measures-as-name-as-dimension-in-filters/m-p/2539952#... I have attached the qvf there and here as well for the reference