topic Chart: Bars in different colors in QlikView

Chart: Bars in different colors

Fri, 28 Oct 2011 12:11:50 GMT

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!

Chart: Bars in different colors

kji — Fri, 28 Oct 2011 12:15:08 GMT

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

Chart: Bars in different colors

Fri, 28 Oct 2011 13:57:07 GMT

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

Chart: Bars in different colors

kji — Fri, 28 Oct 2011 14:01:32 GMT

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)

Chart: Bars in different colors

Fri, 28 Oct 2011 14:07:29 GMT

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

Re: Chart: Bars in different colors

mvaugusto — Fri, 25 Nov 2016 20:16:47 GMT

it works for me!!

Thanks