topic Adding Colors in a Bar Chart in QlikView

Adding Colors in a Bar Chart

Tue, 04 May 2010 11:44:42 GMT

Hi,

I have a small query - can I have differnt colors in a bar chart depending on the value of the dimension?

FIRM REVENUE

A 100

B 110

Client 98

D 95

If I present this data with a bar chart, Can I have a different color for 'Client'?

Tue, 04 May 2010 12:12:54 GMT

hi umang,

in the expressions tab use

if(firm='client',green()) in case u have firm as dimension

thanks

Tue, 04 May 2010 12:14:57 GMT

hi umang,

in the expressions tab under background colour use

if(firm='client',green()) in case u have firm as dimension

thanks

sathishkumar_go — Tue, 04 May 2010 12:36:35 GMT

go to Chart --> Properties-->Expression-->BackgroundColour

In BackGroundColour write if(FIRM = 'Client',rgb(198,222,255))

-Sathish

Tue, 04 May 2010 13:05:25 GMT

Hi and thanks to all for quick responses,

But I still can't get it

I have attached a file if someone will be kind enough to update it and tell me

THANKS

Tue, 04 May 2010 13:11:10 GMT

hi,

pls check the attached application

hope this works for u

thanks

Tue, 04 May 2010 13:21:03 GMT

Thanks a lot tauqueer - you saved my day as usual