topic Re: Colors in Bar graphs in QlikView

Colors in Bar graphs

Mon, 20 Feb 2012 12:24:36 GMT

Hello all,

I have a bar graph with values above 0 and below 0

I like the bars below 0 will be in red and the values abovewill be in green

My expression is a calculated

(sum(A) /above( sum( A))) -1

The graphis attached.

Thank inadvance.

deepakk — Mon, 20 Feb 2012 12:28:08 GMT

hi,

Go to Expression. Expand the plus sign next to expression.

In the background color add this code.

If (column(1) < 0 ,red() , green()).

You can aslo specify the rgb colors as rgb(100,102,123).

Please view the attachment for the further assitance.

Deepak

jagan — Mon, 20 Feb 2012 12:28:25 GMT

Hi,

In expression background color give the following expression

If((sum(A) /above( sum( A))) -1 >0 , RGB(0,255,0), RGB(255, 0,0))

Hope this helps you.

Regards,

Jagan.

Anonymous — Mon, 20 Feb 2012 12:34:04 GMT

Hope the attached file will be helpful for your requirement

Regards

Ashok

Mon, 20 Feb 2012 12:51:36 GMT

thanks a lot

it was very hulpfull and quick.

Cheres,