topic Re: Dynamically hide list box options? in QlikView

Dynamically hide list box options?

Anonymous — Wed, 17 Feb 2016 20:56:28 GMT

I have a few List Boxes in my Qlikview project.

List Box A contains three options:

Books

Music

Curriculum

Then I have a couple other List Boxes, containing dimensions and metrics. These two list boxes are both created from the contents of inline tables specified in the Script.

Some of the dimensions and metrics don't apply to the 'Curriculum' data. If a user chooses 'Curriculum' in List Box A, I would like to disable or hide specific dimensions and metrics in the other two list boxes.

I know that I can conditionally show & hide columns in a chart; I'm doing that in my main chart, when users choose dimensions and metrics. However, since the metrics & dimensions are list boxes, and are loaded from inline tables, I don't know who to show/hide them based on the current selection in List Box A.

Is this possible, and if yes, how can it be done?

Thank you,

Karen

Re: Dynamically hide list box options?

sunny_talwar — Wed, 17 Feb 2016 21:22:15 GMT

May be make a connection between the List Box A and dimensions and metrics.

LOAD * INLINE [

ListBoxA, Dimension, Measure

Books, A, E

Books, B, E

Books, A, F

Books, B, F

Music, A, L

Music, C, L

Music, A, K

Music, C, K

Curriculum, D, P

];

Now when you select Books, you will only see Dimension, A and B and Measure E and F....

Re: Dynamically hide list box options?

Anonymous — Fri, 19 Feb 2016 18:50:33 GMT

Great idea, Sunny. Thank you.

Re: Dynamically hide list box options?

HarveyHarvey — Fri, 20 Oct 2023 09:22:59 GMT

a very bold idea. I found it very useful for me. Can I get your opinion on this please?