How can create a color case ?

[suzel404]

Hi all,

I create a "pseudo planning" and I want to color the case where the store_id contains the date_type

I want to color the case : 1 : 22/07/2015 - 4 : 22/07/2015 - 3 : 05/08/2015 - 108 : 07/01/2016

How can I achieve that ?

Thanks

Regards,

[Anonymous · Accepted solution]

Hi Joshuamoran58,

You could add an expression like the following one in Chart Properties -> Expression --> Background Color.

IF(MATCH(TYPE_ID, 1,3,4,108) > 0 AND DATE_TYPE =

Date#(YEAR&'/'&MONTH&'/'&left(date(CALENDAR_DATE),2), 'YYYY/MM/DD'), RGB(255,0,0))

Please check the attached qvw.

Hope it helps

-- Karla

[suzel404]

Thanks you Karla!

It works.