topic Conditional formatting in bar chart in QlikView

Conditional formatting in bar chart

HitcH — Mon, 26 Jan 2026 18:19:17 GMT

Hello guys

I need to automatically set a different color in a bar chart.

I know that a formula can be set to determine the color, but this works (as far as I know) on the total amount of the expression.

In my example the expression is shown based on the dimension value:

So I want bar on customer B and D on a specific color (as they are <0) and the other on a different color.

If I set the formula it works on the total amount of "var" (which is positive and gives me the same color for all customers).

Thanks in advance

marcus_sommer — Thu, 16 Jun 2022 10:51:15 GMT

Did you apply the color-expression within the attribute-expressions - means by background-color by clicking on the small + sign by the expression?

- Marcus

HitcH — Thu, 16 Jun 2022 11:08:19 GMT

Easy as it seems!

No, I was inputing the formula in the "colors" tab. Thanks a lot 🙂