Google Maps - LA

[#1]

Hi,

i have a project wherein i have to show the sales drop rate for various Latin America countries on Google map. I have tried to replicate the maps from the below link (Google maps sheet)

http://community.qlik.com/docs/DOC-5486

i have attached my excel version wherein the drop rate for each country is represented by a color code. I am facing teh following challenges:

1- The bubbles on the chart don't represent that particular country. The bubble for Mexico is way down then where actual Mexico is located and the same applies for all region

2- the y axis is not hidden even though i have selected the option for hidden

3- When i put the dynamic axis as shown in the example in the above link, the bubbles disappear

4- The size of the bubble should represent the drop rates. As of now all seem to be of the same size

I would really appreciate if someone can help me on this.

Thanks in advance

[sujeetsingh]

See this now

[#3]

Hi Sujeet,

thanks a ton for your reply.

Only 1 request is pending...

How we can keep the bubble size based on the drop rates. For eg: if drop rate is 8 then bubble must be big, if its 1 it should be very small and so on.

Also, i need 2 replicate this map for 3 other metrics. Just the drop rates would be different. Instead of bubbles, is there any other way of presenation so that it looks different from the 1st one.

Thanks a ton.

[sujeetsingh]

Yosuf it seems that the option for this is not working

In properties tab >>>Style Tab    you can get different ways of symbols for datapoints

[#5]

instead of that as an alternative, can we do play with the background color.

If value is from 0 to 3 then bubble color to be blue, if its 4 to 7 then tellow and anything above 7 to be red.

Thanks a ton.

[#6]

it seems the problem is with the drop rates expression.

If i put an ')' at the end the bubbles disappear. also i cant view the values for each country on mouse over. Can you please look into this.

[sujeetsingh]

Yes of course

At expression + sing click

then comes option for Backgound and there write this expression

if(Sum ([Drop Rate])>=0 or Sum ([Drop Rate])>=3,blue(),

  if(Sum ([Drop Rate])>=4 or Sum ([Drop Rate])>=7,Yellow(),LightRed()))

If it helps you then make this question with valid status .

[#8]

I really apprecaite your assistance. Now i can see onlu bubbles in blue. PFA the qvw file for your reference. Also why my 'Drpp rate' expression is not returning any value? i have used sum([Drop Rate]

thanks a ton for your assistance. i need to deliver this in 1 hour. hope we fix this by then.

[sujeetsingh]

http://community.qlik.com/docs/DOC-3136

Go to this link and then carry on the next work

[#10]

That link shows how to craete a map and i have already created one. so i dont think referring to that will help.

What i need is the background color of the bubbles based on the values that we discussed and value of drop rates to be displayed on bubble mouse over.

I believe i made a minor mistake which could be rectified quickly.

Thanks for your constant help.