Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamically hide list box options?

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

Great idea, Sunny. Thank you.

HarveyHarvey
Contributor
Contributor

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