Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.


Conditional formatting bars in a chart


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.

2 Replies

Re: Conditional formatting bars in a chart

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

Honored Contributor

Re: Conditional formatting bars in a chart

May be:

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