Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,.
Further to previous posts on our current application which looks at staisfaction data we want to assign a staisfcation score to as specific colour. The table below confirms what these are. The crucial bit is we need this to work on the maps so when we select a question (there are 7 on this appliction) the colour is both replicated/remebered and also shown on the map.
Satisfaction Score | COLOR | COLOR CODE | R (RGB) | G (RGB) | B (RGB) |
---|---|---|---|---|---|
10 | Green | #4AA02C | 74 | 160 | 44 |
9 | Light green | #7CD25E | 124 | 210 | 94 |
8 | Amber | #CDCD00 | 205 | 205 | 0 |
7 | Yellow | #FFFF00 | 255 | 255 | 0 |
6 | Blue | #0000FF | 0 | 0 | 255 |
5 | Blue | #0000FF | 0 | 0 | 255 |
4 | Light red | #CD4646 | 205 | 70 | 70 |
3 | Red | #FF0000 | 255 | 0 | 0 |
2 | Dark red | #FF0000 | 135 | 0 | 0 |
1 | Black | #000000 | 0 | 0 | 0 |
Can anybody advise where and how this is done?
Chris
Can you send an example?
Example attached
I can't see the map. I don't have that extension.
Hi,
Its a Qlikmap which is an free download of the community. Is it on the map you do the work to show this or somewhere else on the application/program?
Ok, I saw its properties opening from objects in the page.
To set colors by field values I usually do the next:
In the script
Load
Field | CRed | CGreen | CBlue |
A | 25 | 200 | 200 |
B | 200 | 44 | 33 |
C | 20 | 30 | 40 |
Then I use the function rgb(Cred,CGreen,CBlue)
In this case, your expression has to be relocated. If(Score >= 1 and Score is <=10, Red(),Yellow())
If you want to color the first expression, open it up on the plus symbol. Go to Text Color or Back Color and place your expression