topic Full Accumulation and Background Color in a chart in QlikView https://community.qlik.com/t5/QlikView/Full-Accumulation-and-Background-Color-in-a-chart/m-p/370038#M577881 <HTML><HEAD></HEAD><BODY><P>=if(rangesum(Above(column(4),0,Month))&lt;0.RED(),GREEN())</P></BODY></HTML> Mon, 26 Mar 2012 22:17:41 GMT james 2012-03-26T22:17:41Z Full Accumulation and Background Color in a chart https://community.qlik.com/t5/QlikView/Full-Accumulation-and-Background-Color-in-a-chart/m-p/370037#M577880 <HTML><HEAD></HEAD><BODY><P>All -&nbsp; I have a bar and a line chart created where the line has full accum on it. I created an expression for the background color to be&nbsp; </P><P></P><P>if(column(3)-column(2) &lt; 0,RED(),Green()).</P><P></P><P>The issue is even thought the line is full accum, the expression for colors is only looked at for each month.</P><P></P><P>Any ideas?</P></BODY></HTML> Mon, 26 Mar 2012 18:33:40 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-and-Background-Color-in-a-chart/m-p/370037#M577880 james 2012-03-26T18:33:40Z Full Accumulation and Background Color in a chart https://community.qlik.com/t5/QlikView/Full-Accumulation-and-Background-Color-in-a-chart/m-p/370038#M577881 <HTML><HEAD></HEAD><BODY><P>=if(rangesum(Above(column(4),0,Month))&lt;0.RED(),GREEN())</P></BODY></HTML> Mon, 26 Mar 2012 22:17:41 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-and-Background-Color-in-a-chart/m-p/370038#M577881 james 2012-03-26T22:17:41Z