Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
diwakarnahata
Contributor

Predefined RGB colors for each Country

Hi,

I need to put static predefined RGB colors to for each Country. These colors to Country mapping are coming from Excel.

How can I show that color for that country in the Chart?

For e.g. the Bar for India should show the color : RGB(0,164,228).

PFA the qvw and Excel for your reference.

Regards,

Diwakar

Tags (2)
3 Replies
agomes1971
Valued Contributor II

Re: Predefined RGB colors for each Country

Hi,

please see attached.

Kind Regards

André Gomes

hamishimrie
Contributor

Re: Predefined RGB colors for each Country

If you are building an application to be used in the long term it might be better to load the colour associated with each country into a variable on a once-off basis. After that, you can simply maintain the variables (change / edit) when required.

There are many posts on how to import variables via a load script...

Load and use variables from an excel file

Contact me directly should you need specific help

MVP
MVP

Re: Predefined RGB colors for each Country