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

[abhaytrip]

Hi guys ,

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

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

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.

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

[Anil_Babu_Samineni]

What do you mean Behind It?

[abhaytrip]

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.

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

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 · Accepted solution]

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]

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

[ruchirasamant]

Hi,

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

Thanks.