topic Re: Identify common mobile number in Talend Studio

Identify common mobile number

Sunil645454 — Fri, 02 Jan 2026 14:45:42 GMT

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

Re: Identify common mobile number

rubenmarin — Sun, 28 Dec 2025 16:20:35 GMT

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)

Re: Identify common mobile number

ManimekalaiS — Sun, 28 Dec 2025 17:04:57 GMT

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

Re: Identify common mobile number

Sunil645454 — Mon, 29 Dec 2025 14:05:25 GMT

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

Re: Identify common mobile number

Sunil645454 — Mon, 29 Dec 2025 14:06:10 GMT

If you can please elaborate further

Re: Identify common mobile number

rubenmarin — Tue, 30 Dec 2025 07:10:06 GMT

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

Re: Identify common mobile number

Sunil645454 — Tue, 30 Dec 2025 07:21:18 GMT

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.

Re: Identify common mobile number

rubenmarin — Tue, 30 Dec 2025 07:24:09 GMT

Can you upload the qvf to check?

Re: Identify common mobile number

Sunil645454 — Tue, 30 Dec 2025 07:32:27 GMT

Here it is

Re: Identify common mobile number

rubenmarin — Tue, 30 Dec 2025 08:01:43 GMT

Hi, you have your selector in a different altern state

Re: Identify common mobile number

Sunil645454 — Tue, 30 Dec 2025 08:26:20 GMT

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

Thanks rubenmarin

Re: Identify common mobile number

Sunil645454 — Tue, 30 Dec 2025 08:27:56 GMT

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

Re: Identify common mobile number

rubenmarin — Tue, 30 Dec 2025 09:17:28 GMT

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?

Re: Identify common mobile number

Sunil645454 — Tue, 30 Dec 2025 13:20:59 GMT

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
];

Re: Identify common mobile number

rubenmarin — Wed, 31 Dec 2025 07:17:47 GMT

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)

Re: Identify common mobile number

Sunil645454 — Wed, 31 Dec 2025 08:30:43 GMT

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#M4342 I have attached the qvf there and here as well for the reference