Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Select one value in field1 should select another value in field2

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  LanguageName  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 ? 

 

 

 

 

1 Solution

Accepted Solutions
Highlighted

Re: Select one value in field1 should select another value in field2

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

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

View solution in original post

7 Replies
Highlighted

Re: Select one value in field1 should select another value in field2

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

Highlighted
Contributor

Re: Select one value in field1 should select another value in field2

Thanks for your reply Sunny and PFA

 

PFA 

Highlighted

Re: Select one value in field1 should select another value in field2

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

Highlighted
Contributor

Re: Select one value in field1 should select another value in field2

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 . 

Highlighted

Re: Select one value in field1 should select another value in field2

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?

Highlighted
Contributor

Re: Select one value in field1 should select another value in field2

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

Highlighted

Re: Select one value in field1 should select another value in field2

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

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

View solution in original post