topic Re: How can create a color case ? in QlikView

How can create a color case ?

suzel404 — Wed, 15 Jun 2016 04:23:10 GMT

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 — Fri, 17 Jun 2016 23:49:51 GMT

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 — Sat, 18 Jun 2016 20:40:49 GMT

Thanks you Karla!

It works.