Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaytrip
Creator
Creator

On Selection of a Field another Field should be Shown Behind it.

Hi guys ,

I've got a query where I have two fields like this.

ques1.PNG

But I need to show only the Name_1 field on the front and not the Code Word.

ques1-1.PNG

So probably when I click on Name_1 and select A , I must get the Code Word "Stores".

I can try hiding it in the background but I don't think that's going to work as it is seen like this.

ques1-2.PNG

So is there anyway Through which I can Click on A and Get the Related field behind it.

Thanks

Also,

A is for Alfa , Mymistake.

Regards,

Abhay

1 Solution

Accepted Solutions
ruchirasamant
Partner - Contributor II
Partner - Contributor II

Hi,

You can use show/hide condition.

Layout >> Show>> Condition >> if (GetSelectedCount(Name_1)=1,0,1)

and

use a Text object below showing CodeWord

Thanks

View solution in original post

6 Replies
Anil_Babu_Samineni

What do you mean Behind It?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
abhaytrip
Creator
Creator
Author

Maybe not exactly behind it , maybe the show/hide feature could help me with that.

So what my intention is When I click on any value in Name_1 field , I must be able to see the code word related to it.
I hope its understandable , also i'm new to qlik so I have no idea about its boundaries.

Step 1- When I Select C on Name_1 I get charlie below it.

ques1-3.PNG

But what I've Actually done Temporarily is i'm keeping the Code Word Behind the Name_1 by having Layout -> Layer -> Custom = -1.

ques1-4.PNG

So I'm looking for a way by which I don't have to keep the Code Word Behind the Name_1 , instead use the show/Conditional way.
Which i'm unable to do.

Thanks.

ruchirasamant
Partner - Contributor II
Partner - Contributor II

Hi,

You can use show/hide condition.

Layout >> Show>> Condition >> if (GetSelectedCount(Name_1)=1,0,1)

and

use a Text object below showing CodeWord

Thanks

marcus_sommer

The aim of it isn't really clear for me - why not just combining both fields within the listbox with an expression like:

Name_1 & ' - ' & [Code Word]

- Marcus

abhaytrip
Creator
Creator
Author

This worked , this is what I wanted to do !
Thanks

ruchirasamant
Partner - Contributor II
Partner - Contributor II

Hi,

Close the thread....if your issue is resolved...

Thanks.