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 ?
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?
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.
Here user selects AR and it should check within ID(100) for exact value in Name