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

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Wed, 20 Apr 2016 21:55:20 GMT

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'

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

swuehl — Wed, 20 Apr 2016 22:19:00 GMT

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)]

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

Thu, 21 Apr 2016 13:00:50 GMT

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