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

[#2]

any help ?

[sujeetsingh]

See the sample in that thread and go though it it will provide you some helpful fact .

[sujeetsingh]

Use longitude & latitude in dimension and then only the expression as SUm()

make sure that the linked longitude and latiude are correct .

[#5]

Post doing that i am getting too few expressions.

[#6]

Experts please help...

Below are teh problems:

- Drop rates values are not getting displayed

- Bubble size/color is not chnaging based on the value

[#7]

To display a value as a pop up, you need to add a new expression and select the "text as pop-up" option.  Something like this should suffice:

'Drop Rate: ' & Sum([Drop Rate])

As for the marker size, typically the expression that defines the marker size should be the 3rd expression in the listing (Long, Lat, Value).

Good luck.