topic Re: Bar Graph - Colour certain bars specific colours in QlikView

Bar Graph - Colour certain bars specific colours

Wed, 05 Sep 2012 12:44:47 GMT

I have a graph containing a the dimension 'NAME' and and expression that counts the amount of times the name appears in a range of data.

I want to be able to colour two of the bars in the charts. For example the bar with Name X and the bar with name Y.

There are a total of roughly 100 names in my dataset. How do i colour a certain 2?

Is this even possible?

Regards

rajni_batra — Wed, 05 Sep 2012 12:56:55 GMT

in the color tab use calculated color

if(name-namex,RGB(),

if(name=namey,RGB(),

RGB())

hope to help

Wed, 05 Sep 2012 14:31:02 GMT

In the Expressions Tab, expad the Expression used in the Bar Graph and under 'Background Color' use the expression:

=If(Name='<Name1>',Color(6),If(Name='<Name2>',Color(6)))

Replace Color(6) to your desired Color