Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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.
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
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!
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
Thank you! I will try this out. This seems to be what i am serarching for