Help to create Google map and dots representing sales

[#1]

Hi

I am new to QLIKVIEW and try to create map (in freeware version). Attached is the excel file. I have tried to do that but not able to get the dots (scatter chart) on the map which show the sales. (bigger dot shows higher sales)

[#2]

I am not able to open the application sent by you. Plz check it out

[#3]

Thank you Kiruthiga for looking at this. I have uploaded sample1. Please help!!

[Anonymous]

there are different ways to achieve mapping visualizations in qlikview depending on the requirement. sounds like you are trying to implement the scatter plot google maps using dynamic image. you will need gps coordinates to make this work as this particular method requires the coordinates. if you have lat, long fields for the cities, then this is achievable using the link below. there is an example too for reference. easiest way is to copy the script and the object into your qvw file.

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

other methods use mapping extensions such as svg maps, google map heat clusters, heat maps, qlik map, US map with google, etc. each one takes different parameters.

[#5]

Thank you Jsaradhi!! I have tried this with US map with google. Not able to know how to show the dots. Please help how to use scatter chart with US map with google. Please see the sample.xls file.

[#6]

Hello Manish,

What is the type of Geographic Heat Map? It's property is disabled.

As jsaradhi told, If you need to use google map, you can simply download the applns ,reload and check it out  and then add your data as well.

[lironbaram · Accepted solution]

hi

have a look at then attach example

first have a look at the script

i added a loop that geocodes every line and returns the longitude and latitude

for each address

then i added a new tab to load the variables needed to define the map

then in the chart , the map definition is in the colors tab , in the background section

[#8]

Thanks Liron!!

This is what I am trying to achieve.

Thanks

Manish Virmani