full accumulation backgroundcolor

[#1]

Hello,

currently I having following problem....... I have a line chart with target, actual and last year values. Also I have a 4th value with dots to display if the actual is over the target or not. I have to use full accumulation at this chart and the problem is that the color of the dots must change when the actual is above the target. For the background color the full accumulation isn't working. At the background color qlikview compares the monthly values. Is there a way to work here with a set analysis?

I tried to work with a variable but I need the check monthly and not for the full year......

Please find attached the screenshot which i think is more clearly.

regards,
corleone

[Anonymous]

You can try something like this in the Background colour of the Expression (use the + infront of it):

if(Sum ( {$<Year={$(=Max(Year))}>} fieldname)< Sum ( {$<Year={$(=Max(Year)-1)}>} fieldname),RGB(255,0,0),RGB(0,255,0))

[#3]

Hello Dennis,

currently i'm using following code. However, the problem is that the values are compared on a monthly basis (what is correct) but not the accumulated values (YTD for each month).

regards,
corleone

=if(Num(Month)>($(vMonth1)),
 white(),
 if(sum({$<CustomersSelection.CustomerSelected=,Month={'>=1<=$(vMonth1)'}>} Figure ) > [Target] ,RGB(255,60,60),RGB(0,255,0)))