Adding multiple color (RGB) values in Expression

[Anonymous]

Hello,

I'm struggling with adding a specific rgb colorvalue to a specific mapped value, when im plotting a bubble area. For example I've two 2 data tables with a keyfield which is called "ID".

ID	Name
1003	HOSR
1005	DBLB
1006	JZJB
1007	IVRH
1008	PEOM

ID	RGB value
1003	204,51,153
1005	204,51,77
1006	204,153,102
1007	204,179,51
1008	204,255,255

Now I would like to use an expression which tells GeoAnalytics which RGBcode it needs to use for each ID or Name.

Does anyone have a proper solution for this?

[sunny_talwar · Accepted solution]

May be look here

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

[Patric_Nordstrom]

HI Guy,

QGA accepts CSS colors so ='rgba(' & RGBValue & ',1)'

as a string would be the quickest fix.

Splitting up RGB Value in components would also work, either at load time or in expression

=rgb(subfield(RGBValue ,',',1),subfield(RGBValue ,',',2),subfield(RGBValue ,',',3))

Thanks,

Patric

[Anonymous]

Thanks stalwar1‌!

I've tried this one and it's working superb!

I've splitted the RGB code to 3 columns and use the following expression:

=if(Not IsNull(Concurrenten_Gebied_#),RGB(R,G,B))