topic Re: Colors in barchart in QlikView

Colors in barchart

tomgrouwe — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Colors in barchart

prma7799 — Thu, 08 Jun 2017 09:41:02 GMT

Can you please elaborate more? Or send some sample app

Re: Colors in barchart

Anonymous — Thu, 08 Jun 2017 09:45:06 GMT

Post Sample data

Re: Colors in barchart

jonathandienst — Thu, 08 Jun 2017 09:47:44 GMT

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

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

Re: Colors in barchart

micheledenardi — Thu, 08 Jun 2017 09:50:45 GMT

HI Tom, something like this ?

Re: Colors in barchart

tomgrouwe — Thu, 08 Jun 2017 09:57:01 GMT

Hello Michele,

That's exactly what I mean.

Re: Colors in barchart

Siva_Sankar — Thu, 08 Jun 2017 09:57:22 GMT

Hi Tom,

It is possible. Find the attached example.

Re: Colors in barchart

micheledenardi — Thu, 08 Jun 2017 11:23:51 GMT

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,