Discussion board where members can learn more about Qlik Sense App Development and Usage.
Does anyone know of a way to conditionally format the bars in a combo chart.
Basically I have a bar that shows actual cost and a line that show forecast.
When the actuals are bigger than forecast I would like to change the bar to red and when it is below change it to green.
Any help is much appreciated.
If this is Qlik Sense then you can go to Appearance, Colors and Legend and change to custom By expression. Add a color expression something like this:
If(Sum(Actual)-Sum(Forecast)>0, Green(), Red())
If(Sum(Actual) > Sum(Forecast calculation),Green(),Red())