Bar chart conditional format background color with full accumulation

guyvermeiren — Tue, 19 Aug 2014 13:32:11 GMT

Hello,

I have a bar chart where there are 3 values by month. See picture. Actual and Plan are values by Month ( no accumulation) and Var has "Full accumulation". I would like to apply a conditional format to Var (Green when >0 an Red when <0).

I tried with "Background color" (=if(Var <0,Red(),Green()) but this always applies to the Monthvalue and not to the acccumulated value.

Is there are solution for this ?

Thanks,

Guy

Re: Bar chart conditional format background color with full accumulation

Tue, 19 Aug 2014 15:46:38 GMT

You can maybe try this in your background color expression

if(rangesum(above(Expression,0,Rowno()))>0, Green(),Red())

topic Bar chart conditional format background color with full accumulation in QlikView

Bar chart conditional format background color with full accumulation

Re: Bar chart conditional format background color with full accumulation