topic chart display properties in QlikView

chart display properties

Fri, 29 Oct 2010 09:24:22 GMT

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 ?

chart display properties

Fri, 29 Oct 2010 09:29:49 GMT

Hi,

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

Regards.

chart display properties

Fri, 29 Oct 2010 09:44:50 GMT

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 ?

chart display properties

Fri, 29 Oct 2010 10:17:34 GMT

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.