topic Bar Chart Full Accumulation Colour Background Expression in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-Full-Accumulation-Colour-Background-Expression/m-p/527239#M556140 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have a bar chart with full accumulation.&nbsp; Syntax below.&nbsp; How do I colour the bars that have reached the budget. So if the 22nd have exceeded the 79,425,022, I would like the bar to be Green().</P><P></P><P>Expression:</P><P>Sum({&lt;Type={'J'},Date={'&gt;=$(vFYPeriod)&lt;=$(vToday)'},DI_Period=&gt;} Value)</P><P>// J indicates a job, and vFYPeriod is the start of the month.</P><P></P><P></P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 26 Jul 2013 07:18:34 GMT 2013-07-26T07:18:34Z Bar Chart Full Accumulation Colour Background Expression https://community.qlik.com/t5/QlikView/Bar-Chart-Full-Accumulation-Colour-Background-Expression/m-p/527239#M556140 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I have a bar chart with full accumulation.&nbsp; Syntax below.&nbsp; How do I colour the bars that have reached the budget. So if the 22nd have exceeded the 79,425,022, I would like the bar to be Green().</P><P></P><P>Expression:</P><P>Sum({&lt;Type={'J'},Date={'&gt;=$(vFYPeriod)&lt;=$(vToday)'},DI_Period=&gt;} Value)</P><P>// J indicates a job, and vFYPeriod is the start of the month.</P><P></P><P></P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 26 Jul 2013 07:18:34 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-Full-Accumulation-Colour-Background-Expression/m-p/527239#M556140 2013-07-26T07:18:34Z