Colour Coding by Date

Thu, 23 Feb 2012 15:31:20 GMT

Id	Date
1	01/02/2012
2	01/03/2012
3	01/04/2012
...	....

Hello,

I require some assistance!

I have the above dataset, the minimum date in 'Date' is '01/03/2003' and maximum date is '01/01/2021',

I have a rquirement to colour code each record against the Date Column,

Current Month = Red (Feb 2012 at time of writing this)

Current Month+1 = Amber (Mar 2012 at time of writing this)

Anything greater Current Month+2 = Green (Apr 2012 onwards at time of writing this)

Anything less than Current Month = Grey (Jan 2012 backwards at time of writing this)

I understand this could be acheived through alot of nested if's, but was looking for a more elgant solution,

Any advice would greatly appreciated

Re: Colour Coding by Date

Fri, 24 Feb 2012 07:39:51 GMT

There are 2 ways you can do this:

1. Use nested if's in chart background color or text color

2. Add a field that carries the 'colorcode' in script (this would use nested if again). In this approach, all you have to do is add field name into chart background color or text color:

if(MonthName(Date)=MonthName(Today()),LightRed(),
if(MonthName(Date)=MonthName(Today(),1),yellow( ),
if(MonthName(Date)>=MonthName(Today(),2),LightGreen(),DarkGray()))) as ColorCode

topic Colour Coding by Date in QlikView

Colour Coding by Date

Re: Colour Coding by Date