Discussion Board for collaboration regarding Qlik GeoAnalytics.
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".
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?
May be look here
View solution in original post
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))
I've tried this one and it's working superb!
I've splitted the RGB code to 3 columns and use the following expression: