topic Re: Changing Bubble Colors on Maps in QlikView

Changing Bubble Colors on Maps

Tue, 11 Mar 2014 02:47:39 GMT

I have a map created with 5 data points. The pin(bubble) color is the same for each of the 5 data points. What i would like to do is put in a statement that gives me three different colors. If the total estimate 5000 then green, if total estimate 3000 then yellow and if total estimate 1000 then red. Can this be done and if so can someone help me out.

Thanks,

David

Re: Changing Bubble Colors on Maps

Anonymous — Tue, 11 Mar 2014 03:02:37 GMT

what map extension are you using?

Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 09:50:41 GMT

I am not using one. I have not tried extensions. I am not sure how they work or how you set them up.

Re: Changing Bubble Colors on Maps

sudeepkm — Tue, 11 Mar 2014 09:59:41 GMT

Can you please post a sample QVW? I've created a Google static map in the past using a Scattered chart where we were displaying RAG per location (At least one RED will be visible else Yellow or Green).

Re: Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 11:18:05 GMT

Here is my sample data.

Re: Changing Bubble Colors on Maps

Anonymous — Tue, 11 Mar 2014 16:47:13 GMT

instead of the expression you currently have for the background color of longitude, use below for the requirement you have in your first post. adjust accordingly to meet your specific needs:

if(TotalEstimate=5000,rgb(0,255,0), if(TotalEstimate=3000, rgb(255,255,0),rgb(255,0,0)))

Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 17:18:41 GMT

Thank you for your help. I am still learning about maps so I never changed the background color of longitude so I dont know where it is. Can you point it out as I wait I will play around with it.

Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 17:27:59 GMT

Nevermind. Temporary Brain Freeze. Thanks for you help.

David

Re: Changing Bubble Colors on Maps

Anonymous — Tue, 11 Mar 2014 20:19:08 GMT

we have all been there

glad could help!

Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 20:40:53 GMT

I Do have one more question can you put a conditional format that when you select a bubble a chart pops up. I have done it with list boxes and charts.

Re: Changing Bubble Colors on Maps

Anonymous — Tue, 11 Mar 2014 22:24:38 GMT

Well, you can do it with a conditional show on the chart you need....so the chart you want to display would have an expression in the layout tab > show > check conditional something like

Getfieldselections(field)='field value'

I'm not at my computer so can't give you the exact expression. But may be using the field that shows up when you click on a bubble that shows up in current selections may help.

Re: Changing Bubble Colors on Maps

Tue, 11 Mar 2014 22:29:49 GMT

Awesome. I will it later when I am back home.

Re: Changing Bubble Colors on Maps

Anonymous — Wed, 12 Mar 2014 13:49:14 GMT

this should take care of your requirement:

(GetFieldSelections(LocDescription))>0

use the expression above for conditional show.