topic Background color of the straight table cell change according to Month in QlikView

Background color of the straight table cell change according to Month

Fri, 02 Oct 2009 10:55:59 GMT

Hi there,

A question about the color change of the straight table cell. I want to make it yellow or green, depends on whether the corresponding month is an odd or even month. Therefore I used the following formula in the Visual Cues:

if(mod(Month/2)=0,white(),yellow())

However it only shows all white or yellow, not as our expectation...can anyone point out what I have made wrong? Thanks in advance!

Background color of the straight table cell change according to Month

spsrk_84 — Fri, 02 Oct 2009 13:52:36 GMT

Hi,

Thelogic is correct but whether the Month dimension contains 1,2,3.......12 or Jan ,feb,.....dec?

if it is jan --Dec then monthnum fun to get the monthnumber and then apply the logic.

Rgds,

ajay

Background color of the straight table cell change according to Month

johnw — Sat, 03 Oct 2009 00:49:22 GMT

You need a comma instead of a slash, green() instead of white(), and since 0 is false and 1 true:

if(mod(Month,2),yellow(),green())

Background color of the straight table cell change according to Month

rwunderlich — Sat, 03 Oct 2009 06:49:13 GMT


williamcheung wrote:I used the following formula in the Visual Cues

Visual Cues is not the correct property to set for this effect. You should put the (correct) color expression in the "Text Color" or "Background COlor" property of the expression. Access these properties by clicking the + sign next to the expression in the Expression pane. John's attachement shows an example of this.

-Rob

Background color of the straight table cell change according to Month

Wed, 04 Nov 2009 09:21:16 GMT

It's really working, thanks all!

Re: Background color of the straight table cell change according to Month

Tue, 10 Jul 2012 12:44:13 GMT

Very cool! Nice presentation tool