topic Re: color by expression in maps in QlikView

color by expression in maps

Wed, 01 Jul 2015 09:54:09 GMT

Hi, Community.

Am having a problem color coding my maps. Here's a sample table:

areacode	magnitude	proportion
1001	20	.2
1002	25	.25
1003	15	.15
1004	10	.1
1005	30	.3

I would like the the map to color polygons whose values are less than the average of proportion red and those equal and greater than the average proportion green. This expression in color by expression does not work.

If (proportion < Avg(proportion), Red(), Green())

It just shows all the polygons in green.

My map and this table are linked by areacode.

Hope you could help me make this work.

Thanks!

Re: color by expression in maps

Wed, 01 Jul 2015 10:08:15 GMT

Try this,

If (proportion < Avg( Total proportion), Red(), Green())

Re: color by expression in maps

robert_mika — Wed, 01 Jul 2015 10:11:50 GMT

Re: color by expression in maps

Wed, 01 Jul 2015 10:38:40 GMT

Thank you so much! It worked.

I assume the same goes with Min and Max?

Re: color by expression in maps

Wed, 01 Jul 2015 10:39:53 GMT

Thanks so much, Robert. Yes, this worked. But I could only mark one post as the correct answer.

Many thanks for your response.

Re: color by expression in maps

Wed, 01 Jul 2015 10:48:39 GMT

Yes, it is.