Chart: Bars in different colors

[#1]

Hey Guys,

i have a problem with a specific chart.

It looks like this:

What i need is, that the bar changes the color, when it is negative. The prefered solution should look like this:

Positive values black, negative red.

I tried it with some formulas, but it does not work.

Somebody who have an idea?

Thank you very much in advance!

[kji · Accepted solution]

Make a background color expression if(Value<0,Red(),Black())

[#3]

Thank you for your answer!

Unfortunately it does not work. If i try so, every bar gets red, positive ones included.

I have to integrate the formula here, right? ->

Chart properties -> Colors -> Colors 1 - 6 *Select first color* -> Integrate it under basic color formula

[kji]

Sounds like you setting a calculated color for the palette which will not work. You have to set the Background Color Expression (Expression tab, hit the + next to the expression in the expression list, select Background Color)

[#5]

Oh, okay, my fault. (My QlikView Version is not in english) Now it works! Thank you very much!

[mvaugusto]

it works for me!!

Thanks