topic Setting color based on value being selectable ( date range selection/navigation ) in QlikView

Setting color based on value being selectable ( date range selection/navigation )

Fri, 19 Feb 2016 11:28:16 GMT

I'm drawing a bar chart with date as dimension and sum( {1} Data.Counter ) as expression, to get a full view of item count over time.

I'd like to set the color of currently selected dates, like this

I know I can set color in the properties of the expression

But I can't figure out the if -expression I should use. Does anyone know how to achieve this? What I'm looking for is something like

if ( CurrentDate IN SelectedDates, RGB(0, 0, 0), RGB(255, 255, 255) )

marcus_sommer — Fri, 19 Feb 2016 12:24:59 GMT

You could try something like this:

if(YourDateField, red())

or maybe

if(Year = getfieldselections(Year), red())

- Marcus

hic — Fri, 19 Feb 2016 12:30:27 GMT

I would use something like

If(Count(Date)>0, LightGreen(), LightGrey())

HIC

tresB — Fri, 19 Feb 2016 12:40:23 GMT

Or, may be even like,

If(Date=Date, LightGreen(), LightGrey())

Edit: Well,

Marcus's: if(YourDateField, red()) is even simpler.