Conditional colouring of barchart

[#1]

I use this expression

count(if(ANMAAR='2013',JOURNALNR))

and would like to set a condition than the bar turns red if the count is greater than 2013????????

something like this

count(if(ANMAAR='2013' and ANMAAR > '2012',JOURNALNR))

[sushil353]

try this:

expand the expression and click on background color.

then put your condition in the definition box

=if(count(ANMAAR)>2013,red())

HTH

Sushil

[#3]

Hi,

try with this expression as a value of Background color of the chart:

if(num#(ANMAAR)>2013, rgb(255,0,0))

regards

[#4]

hi,

    Try this

if(  count(ANMAAR)>=2013,JOURNALNR)

//Yusuf

[#5]

MAybe a little more explanation is needed

the bar is green and if the count of 2013 is greater than the count 2012 it should be red - that is what I´d like it to do

[er_mohit]

in expression tab you see the  '+'  icon  on expression click on it

and go to backgroung colour there you put condition

f(ANMAAR>2013,lightred())

[raghavsurya]

Hi,

You can give the condition in "BackGround Color" option of expression using RGB functionality to display the colour you want based on the selection.

Regards,

Raghav

[kogasawara]

try this

count({<ANMAAR={"2013"},ANMAAR={">2012">}JOURNALNR)

[#9]

Hi Polschou,

To change the bar chart colouring,  may be you can try to follow the below steps,

right click on bar chart --> select properties--->go to expression tab--> add the definition for the chart such as in your case it should be something like if(count>2013,yellow()). try and see if it works.

[Anonymous]

hi

In the expression tab of the chart property, expand the plus sign along with the expression and add expression for background colour as follows

          =If(ANMAAR>'2013', RGB(255,0,0))

Regards

Revathy