chart display properties

[#1]

Hi all

Am trying to make a chart show red when <0 and green when >=0 but this does not seem to work

i have put the following expression

=

IF([Actual MC]-[Plan MC]<0, Red(), Green() )

I have nothing in the dimmensions and am using a barchart

any ideas why the bar chart is showing in blue rather than green as the value is greater than 0 ?

[#2]

Hi,

Mine seems to be working fine, try putting a number 255 inside the (), like red(255),green(255).

Regards.

[#3]

Hi Tan

Thanks for the reply mine still does not work, I tried putting 255 inside the () but made no change,

am basically working out a variance and trying to say if it is a negative number the bar should show red, if it iss positive show green but not working for me. Am using v9 what about you ?

[#4]

Hi,

I did the same thing, it will return a red bar if its a negative number and green bar for positive, the formula worked great. im using v9 SR3.

Maybe you should try contacting qliktech for this. as it might be a bug.

Regards.