Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Thanks in advance
Please provide some sample data or the QVW file for reference.