Is it possible to show a list object based on the value selected in another list object?

[#1]

Hi, Everyone,

I have a question about list objects. Is it possible for QlikView to show a list object based on the value selected in another list object? For example, there is a List object Dimension with the following values: Age, Gender, Income. There are also specific values for each of the dimension. If I select "Age" in the Dimension list, I would like to see the list object with specific values (Below 20, 20 - 40, etc.) of Age showing up, but not others. If I then select "Gender", I would like to see the list object with "Male", "Female" showing up but the Age list should disappear.

Is it possible for QlikView to have this functionality? Thank you very much for your answer !!

[sunny_talwar · Accepted solution]

Yes you sure can do that. You just need a show/hide condition on the layout tab for each of the list box that need to show or hide.

For Age, you can use this -> =GetFieldSelections(Dimension) = 'Age'

For Gender -> =GetFieldSelections(Dimension) = 'Gender'

[swuehl]

If you have a lot of these fields, there is another option;

Create a single list box with show condition on layout tab

=GetSelectedCount(Dimension)

And use a calculated dimension (select <expression> from field drop down on general tab)

=[$(=Dimension)]

[#4]

Thank you both for the suggestions! They work very well!