https://community.qlik.com/t5/QlikView/Bar-chart-color-by-expression-per-variable/m-p/1947486#M1219618 <P>Hi,&nbsp;</P> <P>I have created a bar chart containing the sales per week. What I'm trying to do is to let the individuals bars be red when sales &lt; budget and green when Sales &gt; budget. In Qlik sense I have set the Y-axis color on the following expression:</P> <P>=if((sum([Budget])&lt;sum([Sales])),red(),green())</P> <P>Subsequently Qlik shows all bars in the same color since it compares the revenue and budget on aggregated total level in stead of the individual weeks.&nbsp;</P> <P>Does anyone have a solution how I can set the expression for each week separately?</P> <P>Thanks in advance</P> Thu, 23 Jun 2022 14:53:26 GMT robintw 2022-06-23T14:53:26Z https://community.qlik.com/t5/QlikView/Bar-chart-color-by-expression-per-variable/m-p/1947486#M1219618 <P>Hi,&nbsp;</P> <P>I have created a bar chart containing the sales per week. What I'm trying to do is to let the individuals bars be red when sales &lt; budget and green when Sales &gt; budget. In Qlik sense I have set the Y-axis color on the following expression:</P> <P>=if((sum([Budget])&lt;sum([Sales])),red(),green())</P> <P>Subsequently Qlik shows all bars in the same color since it compares the revenue and budget on aggregated total level in stead of the individual weeks.&nbsp;</P> <P>Does anyone have a solution how I can set the expression for each week separately?</P> <P>Thanks in advance</P> Thu, 23 Jun 2022 14:53:26 GMT https://community.qlik.com/t5/QlikView/Bar-chart-color-by-expression-per-variable/m-p/1947486#M1219618 robintw 2022-06-23T14:53:26Z https://community.qlik.com/t5/QlikView/Bar-chart-color-by-expression-per-variable/m-p/1948046#M1219638 <P>Please provide some sample data or the QVW file for reference.&nbsp;</P> Fri, 24 Jun 2022 18:43:47 GMT https://community.qlik.com/t5/QlikView/Bar-chart-color-by-expression-per-variable/m-p/1948046#M1219638 sk88024 2022-06-24T18:43:47Z