topic How to create google map in qlikview in QlikView

How to create google map in qlikview

farheenayesha — Mon, 01 Dec 2014 13:47:17 GMT

Hello,

I am trying to create google map using the attached data. I have added logitude and latitude values to the excel sheet but still nothing is showing up. Kindly help me to create it.

Re: How to create google map in qlikview

jpenuliar — Mon, 01 Dec 2014 13:55:43 GMT

Hi Ayesha,

you didn't include the Lat & long values of Issues, try reload with the corresponding values into your table.

And if you followed all the necessary steps from the API guide, your map should be sorted

Re: How to create google map in qlikview

farheenayesha — Mon, 01 Dec 2014 14:03:15 GMT

Thanks for the reply Jon. I am not understanding how to make the changes which you have mentioned. If you dont mind could you please make the changes and send it back to me.

Re: Re: How to create google map in qlikview

jpenuliar — Tue, 02 Dec 2014 10:48:20 GMT

Hi Ayesha,

I created a table of Countries with Long & Lat from you Issues sheet(excel) and load it in Qlikview.

You can Load Issues Table and link it to Country to be able to sum(Issues) in your Map.

Pretty much all the maps i've seen implement with a Location type Dimension(City.Town,Country, etc...), one that will be tied to a geolocation. Your example was using Product code, If you want to show count of distinct Product issues per country, you might want to add listbox of products, or Issues to be able to make a distinct analysis on your map visual.

as for the background map, you still havent added the code in chart properties>>Color>>Dynamic Image.

Please refer to the API guide.