topic Conditional formatting bars in a chart in App Development

Conditional formatting bars in a chart

aworrall — Sat, 16 Nov 2024 08:02:01 GMT

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.

Re: Conditional formatting bars in a chart

Lisa_P — Thu, 28 Jun 2018 03:12:00 GMT

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

Re: Conditional formatting bars in a chart

BalaBhaskar_Qlik — Thu, 28 Jun 2018 10:33:16 GMT

May be:

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