Colors in barchart

[tomgrouwe]

Dear experts,

In my dashboard i have a barchart with a reference line that is set at 98%.

Is it possible that the barcolors in the barchart change, when the reference line is met or not? (Green 98% or >, Red or yellow when < than 98%)

[prma7799]

Can you please elaborate more? Or send some sample app

[Anonymous]

Post Sample data

[jonathandienst]

It is possible. Set the background colour (click + next to the expression on the Properties | Expressions tab to get to these properties) to a conditional expression that sets the colour according to your requirements. Something like

    =If(Column(1) > 0.98, green(), red())

    or

    =If(<column expression here> > 0.98, green(), red())

[micheledenardi · Accepted solution]

HI Tom, something like this ?

[tomgrouwe]

Hello Michele,

That's exactly what I mean.

[Siva_Sankar]

Hi Tom,

It is possible. Find the attached example.

[micheledenardi]

Hi Tom,

please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,