topic Re: Colouring Specific Months Using Expression in Background Colour in QlikView

Colouring Specific Months Using Expression in Background Colour

Sun, 13 Jan 2013 18:56:34 GMT

We have a Straight Chart in horizontal format. Using expressions we have data rows of inventory data in monthly bucket columns.

We want to use the background colouring to identify (visual clue) when the freeze fence (lead time) from the current month.

For example:

If this was month 6 (June) and the Freeze Fence is 3 months - therefore, the cells in months 6, 7 & 8 should be purple and months 1-5 and 9-12 would remain grey

Month1	Month2	Month3	Month4	Month5	Month6	Month7	Month8	Month9	Month10	Month11	Month12
100	50	50	75	100	50	50	100	75	100	50	50

Needless to say each SKU will have it's own freeze fence of 0 to whatever so we do not want to colour the header.

I'm hung up on the IF statement ... currently I have

if ((CalMonth) < (FreezeFence), RGB(90,0,150), RGB(100,100,100) )

Just having a brain fart on the logic - I know I need to add the freeze fence value to the month number less 1, then colour those months purple and the rest gray.

Please and Thank you in advance!

Re: Colouring Specific Months Using Expression in Background Colour

Mon, 14 Jan 2013 01:23:16 GMT

Hi,

Please look at attached document. Special case is when the freeze goes over into the next year.

I've solved that by checking if the freeze goes over the next year.

Kind Regards,

Dion

Re: Colouring Specific Months Using Expression in Background Colour

sujeetsingh — Mon, 14 Jan 2013 06:46:13 GMT

Well reply by Deon!!

Re: Colouring Specific Months Using Expression in Background Colour

Mon, 18 Mar 2013 20:13:40 GMT

Hi Dion! Thank you so much for your help! It worked great with a little tweaking specific to our need. I'm terribly sorry for the delay - work - life - stuff - got in the way!

Have a grrreat day!

Däv