Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be look here
http://www.qlikfix.com/2010/12/17/consistent-dimension-colors/
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
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))