topic Re: How can I change the colour of this chart when it is above a threshold? in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/943483#M325163 <HTML><HEAD></HEAD><BODY><P>Use this as backgroundcolor expression</P><P></P><P>if(</P><P>Count(DISTINCT OrderID) &lt; </P><P>Avg(total Aggr(Count(DISTINCT OrderID), MonthYear)),</P><P>LightRed()</P><P>)</P></BODY></HTML> Thu, 05 Nov 2015 12:47:05 GMT Clever_Anjos 2015-11-05T12:47:05Z Bar Chart https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/943482#M325162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In a chart I would like to change the colour of the line when it is above the reference line. E.g. to Red.</P><P></P><P>Anyone know how this is possible please?</P></BODY></HTML> Thu, 05 Nov 2015 12:11:13 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/943482#M325162 mwallman 2015-11-05T12:11:13Z Re: How can I change the colour of this chart when it is above a threshold? https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/943483#M325163 <HTML><HEAD></HEAD><BODY><P>Use this as backgroundcolor expression</P><P></P><P>if(</P><P>Count(DISTINCT OrderID) &lt; </P><P>Avg(total Aggr(Count(DISTINCT OrderID), MonthYear)),</P><P>LightRed()</P><P>)</P></BODY></HTML> Thu, 05 Nov 2015 12:47:05 GMT https://community.qlik.com/t5/QlikView/Bar-Chart/m-p/943483#M325163 Clever_Anjos 2015-11-05T12:47:05Z