topic Set chart backcolor based on MonthName function in QlikView

Set chart backcolor based on MonthName function

Thu, 06 Aug 2009 20:52:41 GMT

Hi I have a chart with a dimension of Monthname(Date), I want to set the backcolor of an expression depending upon what month it is, however i cant work it out. I have used the following expression

if(MonthName(myDate) ='Oct 2007' Or MonthName(myDate) = 'Nov 2007' , LightRed),

Can anyone please advise, I take it its because 'Oct 2007' is being read as a string as opposed to the date but i'm not sure how to go about converting it into the correct date type.

thanks

Set chart backcolor based on MonthName function

prieper — Fri, 07 Aug 2009 03:07:52 GMT

Hi,

the colour-names are functions and need to end with () , thus your example should work with:

if(MonthName(myDate) ='Oct 2007' Or MonthName(myDate) = 'Nov 2007' , LightRed()),

HTH

Peter

Set chart backcolor based on MonthName function

Fri, 07 Aug 2009 17:23:35 GMT

Hi Peter,

Sorry the missing brackets were a typo, it still doesn't work with the brackets, any ideas why?

Thanks

Set chart backcolor based on MonthName function

Fri, 07 Aug 2009 18:18:39 GMT

Hi onlyone,

see the attached example. Is this kind of coloring what you want to have?

Rainer