topic Re: Bar chart going below '0' in QlikView

Bar chart going below '0'

Tue, 10 Nov 2015 13:26:46 GMT

Hello there,

is there a way to show this graph with all the red columns (minus 0) to be graphically below '0' and only the 2 green columns as they are right now.

thanks for your help

Mark_Little — Tue, 10 Nov 2015 13:39:04 GMT

Hi,

It should be possible. Are you using the FABS() function to make the values all Positive?

If so you could add a expression to the background colour.

In the chart properties > expressions. Press the little plus symbol click on the Background colour

Add the below in the definition

IF(SUM(Value) > 0, Red(), Green())

You could change the colour to RGB values.

Mark

Tue, 10 Nov 2015 13:45:36 GMT

Thanks Mark, it was the Fabs

now it is ok