topic How do you keep a value from displaying on the Slider? in QlikView

How do you keep a value from displaying on the Slider?

Anonymous — Thu, 03 Sep 2015 07:22:15 GMT

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!

Re: How do you keep a value from displaying on the Slider?

Anonymous — Mon, 07 Sep 2015 11:14:11 GMT

Does anyone know a solution to the above? Thanks!

Re: How do you keep a value from displaying on the Slider?

Anonymous — Mon, 14 Sep 2015 14:50:13 GMT

Didn't get an answer but figured it out - apparently I had so many fields and I missed seeing <Expression> from the Field dropdown of the Slider/Calender Object Properties. So I simply did =if(CategoryA<>'GHI',CategoryA) and that solved it.