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))

[Anonymous]

GO TO EXPRESSION TAB -> EXPAND IT -> Click on expression tab write following expression -

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

hope this helps !!!

ANANT

[VishalWaghole]

Hi,

PFA here with screen shot where we can apply loggic to change color of bar.

Thanks and Regards,

Vishal Waghole

[#4 · Accepted solution]

solved by using Background Color and this

=

if(count(if(ANMAAR='2013',JOURNALNR)) >= count(if(ANMAAR='2012',JOURNALNR)), rgb(255,0,0), rgb

(164,216,105))