Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aworrall
Luminary Alumni
Luminary Alumni

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.

Labels (1)
  • Chart

2 Replies
Lisa_P
Employee
Employee

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

May be:

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