topic Re: colour map in QlikView

colour map

Fri, 05 Apr 2013 08:18:54 GMT

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

Re: colour map

christian77 — Fri, 05 Apr 2013 08:33:38 GMT

Can you send an example?

Re: colour map

Fri, 05 Apr 2013 08:38:07 GMT

Example attached

Re: colour map

christian77 — Fri, 05 Apr 2013 08:46:00 GMT

I can't see the map. I don't have that extension.

Re: colour map

Fri, 05 Apr 2013 08:50:45 GMT

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?

Re: colour map

christian77 — Fri, 05 Apr 2013 08:54:16 GMT

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