Hi Qlikview Experts,
I have a simple line chart where the dimension is CategoryA, which has the following values: ABC, DEF, GHI. I have a slider for the user to select which range of dimensions to display. I configured the chart to always include GHI. Because GHI is always included, it is redundant to display GHI on the slider. In order to work around this, I created an additional column, CategoryA_1, where the value is blank where CategoryA=GHI. I then use this field, CategoryA_1, for my slider. Problem is using CategoryA_1 is excludes the dimension, GHI.
My data looks like this:
| CategoryA | CategoryA_1 | CategoryB | Data |
|---|
| ABC | ABC | Apple | 2 |
| ABC | ABC | Apple | 10 |
| ABC | ABC | Orange | 5 |
| DEF | DEF | Apple | 20 |
| DEF | DEF | Orange | 10 |
| GHI | | Apple | 5 |
| GHI | | Apple | 20 |
| GHI | | Orange | 5 |
Please see attached.
Hoping for any advice! Thanks!
