Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a bar chart which gives me a bar for the target of sales - actual sales in each department to see what the variance is.
If the bar in the chart is less than 0 i want it to be green and if the bar is greater that zero i want it to be red.
Can you tell me how to do this, this is a picture of the chart below.
So i want to make the second bar green as it is below 0.
Go to Solution.
in expression tab on + icon of bar chart you ll see the backround color then click on it and put expression which you use for variance
in if condition
if(variance>0 ,lightred(),lightgreen ())
hope it helps
If you go to the expression tab and collapse the expression you can change the colour of the bars in the background colour item.
Do something like:
Hopes this helps.
See the below screen Short and attached file. You can able to add condition here