Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Make a background color expression if(Value<0,Red(),Black())
Make a background color expression if(Value<0,Red(),Black())
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
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)
Oh, okay, my fault. (My QlikView Version is not in english) Now it works! Thank you very much!
it works for me!!
Thanks