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 < budget and green when Sales > budget. In Qlik sense I have set the Y-axis color on the following expression:
=if((sum([Budget])<sum([Sales])),red(),green())
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.
Does anyone have a solution how I can set the expression for each week separately?
