background color in expression

rcorcoran — Thu, 19 Nov 2015 09:58:01 GMT

I have the following expression in background colour of an expression in a chart it works fine but I want it to only show for 2015 on and to have a white background for 2014 as the variable it is measuring against wasn't there for 2014.

Any help appreciated

if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')>=[vtarget MH1 5%],RGB(81,173,152),
if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')<[vtarget MH1 10%],RGB(208,62,81),
if(num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')>=[vtarget MH1 10%] and
num(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,22,23,24,25,26,27,28,29,30,33,34,35,36,37,38,39,40,41,42,43,44,47,48,49,50,51,52,53,54,55,56,57,58}>}ActualValue)/
(Sum({$<[GenAdult]={5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60}>}ActualValue)), '##0%')<[vtarget MH1 5%],RGB(233,174,17))))

topic background color in expression in QlikView

background color in expression