Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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())