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

[rubenmarin]

Hi, if you don't want to show your current selection in the table, the expression could be:

Only({<Mobile_Number=P(Mobile_Number), Reference_ID={"*"}-P(Reference_ID)>} Mobile_Number)

To also show the selected Reference_ID it could be:

Only({<Mobile_Number=P(Mobile_Number), Reference_ID=>} Mobile_Number)

[ManimekalaiS]

Create 1 variable. In that variable predict  GetFieldSelection(RefID) mobile no. In table chart using set analysis pass this variable to mobile no field and get the refid's

[Sunil645454]

Only({<Mobile_Number=P(Mobile_Number), Reference_ID={"*"}-P(Reference_ID)>} Mobile_Number) - this is giving me hypen no records and 

Only({<Mobile_Number=P(Mobile_Number), Reference_ID=>} Mobile_Number) - give me all three records

[Sunil645454]

If you can please elaborate further

[rubenmarin]

Hi, I did a test with your sample data and it works:

[Sunil645454]

Please check this , i am getting this and I just had inline load nothing else for these three records and in front end you can see how it is coming when filtered.

[rubenmarin]

Can you upload the qvf to check?

[Sunil645454]

Here it  is

[rubenmarin]

Hi, you have your selector in a different altern state