Qlik Community

Qlik Sense App Development

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

Highlighted
Luminary
Luminary

Conditional formatting bars in a chart

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.

2 Replies
Employee
Employee

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

balabhaskarqlik
Honored Contributor

Re: Conditional formatting bars in a chart

May be:

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