topic full accumulation backgroundcolor in QlikView

full accumulation backgroundcolor

Wed, 09 Feb 2011 14:28:56 GMT

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

full accumulation backgroundcolor

Anonymous — Wed, 09 Feb 2011 20:37:06 GMT

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

full accumulation backgroundcolor

Thu, 10 Feb 2011 10:22:29 GMT

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