Conditional formatting bars in a chart

[aworrall]

Hi

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.

[Lisa_P]

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())

[BalaBhaskar_Qlik]

May be:

If(Sum(Actual) > Sum(Forecast calculation),Green(),Red())