topic Enterprise colors for dimensions in QlikView

Enterprise colors for dimensions

tabletuner — Mon, 02 Jan 2012 12:34:00 GMT

Hi Community,

I'd like to use the same colour for a dimension value in every qvw application in my enterprise.

For example:

I have a 2 countries:

Holland

Belgium

Holland should always be displayed blue and Belgium should always be displayed red in all my applications. Is there a way to maintain this centrally?

Regards,

Tjeerd Wieberdink

Enterprise colors for dimensions

swuehl — Mon, 02 Jan 2012 19:43:08 GMT

Yes, you could add the rgb() color values to your database, in the country dimension table (or create a lookup table in a different DB and link tables in script). Then set the colors in your table in the e.g. background color attribute expressions (expression tab, open attributes by clicking on the plus sign).

Enterprise colors for dimensions

Tue, 03 Jan 2012 05:49:03 GMT

Tjeerd,

There are multiple ways of doing this. Either you add the colors somewhere as a datasource easily linked to the entity in your datamodel, and read it in all QVW's (as an excel file or a QVD) or you can create an include file that contains variables for each color and include this file in all your QVW's. All depends upon the size of your project, number of colors involved, etc.

Regards,

Rob

Enterprise colors for dimensions

swuehl — Tue, 03 Jan 2012 12:38:04 GMT

Just adding some links for the same approach:

http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/

http://community.qlik.com/message/130811

Re: Enterprise colors for dimensions

IAMDV — Tue, 03 Jan 2012 13:26:40 GMT

Hi Tjeerd Wieberdink,

I have created a video post on this topic. Here is the link...

http://qlikshare.com/41

I hope this helps!

Cheers - DV

Re: Enterprise colors for dimensions

tabletuner — Tue, 03 Jan 2012 15:40:57 GMT

Thank you all for your input. The RGB trick is working well enough.