Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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....
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....
Great idea, Sunny. Thank you.
a very bold idea. I found it very useful for me. Can I get your opinion on this please?