topic Conditionally colouring Bars in a Chart/Reference Lines in QlikView https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417385#M1168838 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I have a bar chart detailing sales for my companies.</P><P></P><P>I want to display a reference line with the mean of the sales for that company. (Avg(Amount)). I also want to display 2 more lines showing +/- vThreshold%. So far I think I have implemented these.</P><P></P><P> I now I want to colour the bars on the chart which do not fit within the specified threshold. So if the average is 50 and the theshold is 10%, a value of 60 or 40 will be red, and blue otherwise</P><P></P><P>It makes much more sense in the attached file. Im sure theres some set thing im missing in my Background Color expression. Help! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Sep 2012 12:35:45 GMT 2012-09-18T12:35:45Z Conditionally colouring Bars in a Chart/Reference Lines https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417385#M1168838 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I have a bar chart detailing sales for my companies.</P><P></P><P>I want to display a reference line with the mean of the sales for that company. (Avg(Amount)). I also want to display 2 more lines showing +/- vThreshold%. So far I think I have implemented these.</P><P></P><P> I now I want to colour the bars on the chart which do not fit within the specified threshold. So if the average is 50 and the theshold is 10%, a value of 60 or 40 will be red, and blue otherwise</P><P></P><P>It makes much more sense in the attached file. Im sure theres some set thing im missing in my Background Color expression. Help! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Sep 2012 12:35:45 GMT https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417385#M1168838 2012-09-18T12:35:45Z Re: Conditionally colouring Bars in a Chart/Reference Lines https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417386#M1168839 <HTML><HEAD></HEAD><BODY><P>I think, you've forgotten about total qualifier:</P><P>=if((Amount &lt; avg(<STRONG>total </STRONG>Amount)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *(100-vThreshold)/100)&nbsp;&nbsp;&nbsp; ,LightRed())</P></BODY></HTML> Tue, 18 Sep 2012 13:14:10 GMT https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417386#M1168839 whiteline 2012-09-18T13:14:10Z Re: Conditionally colouring Bars in a Chart/Reference Lines https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417387#M1168840 <HTML><HEAD></HEAD><BODY><P>Try this.</P></BODY></HTML> Tue, 18 Sep 2012 16:07:06 GMT https://community.qlik.com/t5/QlikView/Conditionally-colouring-Bars-in-a-Chart-Reference-Lines/m-p/417387#M1168840 2012-09-18T16:07:06Z