Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Creator
Creator

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

Thanks for your reply Sunny and PFA

 

PFA 

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
Creator
Creator

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
Creator
Creator

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