topic Re: Help to create Google map and dots representing sales in QlikView

Help to create Google map and dots representing sales

Tue, 22 Apr 2014 18:15:50 GMT

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)

Re: Help to create Google map and dots representing sales

Tue, 22 Apr 2014 18:20:29 GMT

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

Re: Help to create Google map and dots representing sales

Tue, 22 Apr 2014 18:34:07 GMT

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

Re: Help to create Google map and dots representing sales

Anonymous — Tue, 22 Apr 2014 18:46:40 GMT

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.

Re: Help to create Google map and dots representing sales

Tue, 22 Apr 2014 18:58:22 GMT

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.

Re: Help to create Google map and dots representing sales

Tue, 22 Apr 2014 19:01:35 GMT

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.

Re: Help to create Google map and dots representing sales

lironbaram — Tue, 22 Apr 2014 19:19:31 GMT

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

Re: Help to create Google map and dots representing sales

Sun, 27 Apr 2014 14:02:55 GMT

Thanks Liron!!

This is what I am trying to achieve.

Thanks

Manish Virmani