can i set global colour for the different charts based on the value of the dimension?

[#1]

How can i set global colour for the different charts based on the value of the dimension?

For example, I have data with the dimension region. The are 4 values in region - North, South, East and West. I want all belonging to the North region to be a colour, all to the South colour to be another colour and so on.

Thank you!

[#2]

Hi Sangram,

I am currently using the colour expression but am doing so for all the charts. Do you mind elaborating more on "colours table in your data model which can be used to easily alter the colours of all the visualizations easily". I would love to do that.

Thank You!

[reddy-s]

Hi Wei,

You can do something like this using an Inline load:

lets say you have Regions Column( with values "North,South,East,West") in your data model

Load an inline table this way:

[Colours]:

load * Inline [

Regions, Red, Green, Blue

North, 157, 198, 216

South, 125, 207,182

East, 0, 178, 202

West, 29, 78, 137

];

Now the Region field in the Colours tables is linked to the data model on the Regions field.

Use this as your colour expression now:

rgb(Red, Green, Blue)

Thanks,

Sangram.

[sunny_talwar]

I did propose this, but either the OP did not like the idea or she/he never saw the link I posted

Maintaining Color of the Dimensions in QlikView – Learn QlikView

[reddy-s]

[#6]

Hi Sunny! The doc you recomended Was very usefull for me, thanks! But  Wei Shong said he/she is using Qlik Sense! And not QlikView!

[Michael_Tarallo]

Hi Wei, great to hear, you can define expressions like this in the variable editor to make them more global, take a look:

(You can also do this in the Load Script)

Qlik Sense - Variables Interface (video)

Please note:

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[#8]

Thank you! I will try this out. This seems to be what i am serarching for