Select one value in field1 should select another value in field2

[CVR]

Hello Qlik Geeks,

I have a tricky requirement. I have three fields Language,Name,ID from same table. On dashboard user was given only field option to select values which is  Language. Name  values should be displayed according to the language but the for each language there are multiple names (possible values) and the exact name is displayed only when both Name and ID are selected. 

How to achieve this ? 

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[CVR]

Thanks for your reply Sunny and PFA

PFA 

[sunny_talwar]

So when you select AR, what exactly do you want to see in the text box object?

[CVR]

Each ID has a Name and When I select AR and 100 then I get Name=CU here I should get that without selecting ID . 

[sunny_talwar]

But without you selecting, how would the dashboard know that you want to see Name = CU? I mean what if one day you wanted to see DES instead of CU... how should Qlik determine what you want to show?

[CVR]

Sorry, if I was not clear. So, here each ID field value has  Names. For example if you select '100' then u can see AC, CU,KO gets associated and each of these is a separate language word. 

AR--->100---->CU

DE--->100---> KO

EN---->100--->AC

Here user selects AR and it should check within ID(100) for exact value in Name

[sunny_talwar · Accepted solution]

Okay so you only need the name for ID = 100 in the text box? Try this

=Only({<ID = {100}>}NAME)