topic Re: Colors assigned to an attribute in QlikView

Colors assigned to an attribute

Wed, 03 Aug 2011 14:49:15 GMT

Gang, can I assign a color to an attribute? For example, if i have a pie chart of sales - I want Honda to always come up as Red, Ford to come up as Blue, and Toyota as Green.

Seems that when i reload my data set the color scheme always changes.

Any suggestions?

Re: Colors assigned to an attribute

martin — Wed, 03 Aug 2011 14:54:32 GMT

Hi,

Look at the attachment, it's an application wich do that.

The color code is mentionned in the script editor.

Hope that helps you.

Martin

Re: Colors assigned to an attribute

rahulgupta — Thu, 04 Aug 2011 09:18:52 GMT

Hey Hi,

In the Expression tab >> Expand the Expression >> Background Color >> Use the following expression:

=If(Brand='Honda',Red(),

If(Brand='Ford',Blue(),

If(Brand='Toyota',Green())))

Look at the App Below.

Hope this helps..

Regards

Re: Colors assigned to an attribute

SunilChauhan — Thu, 04 Aug 2011 10:00:47 GMT

lease see the attached

Re: Colors assigned to an attribute

Thu, 04 Aug 2011 10:06:06 GMT

Hi,

In Properties ---> Color ---> Persistent colors.

If you click the above option in pie chart properties , the colors wont get change.

Regards,

Antony.