topic Google Maps Question in QlikView

Google Maps Question

dradoikov — Mon, 25 Jul 2011 18:41:51 GMT

Hello,

I need some help in building a Google maps integration.

I have enclosed a file with test data.

The purpose of the analysis is to visualize data in cities, without using GPS coordinates.

Please help

thanks

Google Maps Question

Mon, 25 Jul 2011 19:07:32 GMT

I don't understand.

You need coordinates to put cities in a scatter plot with a Google Maps background.

If you want to get longitude/latitude you can submit request to Google API.

JJJ

Re: Google Maps Question

dradoikov — Mon, 25 Jul 2011 19:23:13 GMT

ok,

but can you give me an example.

I have not used the Google API.

thanks

Re: Google Maps Question

Mon, 25 Jul 2011 20:40:05 GMT

if you request like this :

http://maps.google.com/maps/geo?q=plovdiv&output=csv

you get this results

200,4,42.1438409,24.7495615

The 2 last fields are longitude & latitude

You can create a script in QV to catch the coordinates with a loop.

See the attachment

Hope it helps you

Google Maps Question

Tue, 26 Jul 2011 06:59:57 GMT

Hi,

Please refer the below link

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

and u must have latitude and logitude in your data

Hope it helps u.

Regards,

Sri

Re: Google Maps Question

Tue, 26 Jul 2011 18:44:04 GMT

The link is broken Sri

Re: Google Maps Question

qliksus — Mon, 23 Jan 2012 08:55:47 GMT

Hi, I just downloaded the Google Maps in QlikView.qvw from QlikView 9 sample files and i just followed the steps written inside the application. For the latitude & longitude, i got from your sample file. After reload the file mine Location are not coming in correct postion.

Can u help me to solve this error???

Re: Google Maps Question

Mon, 23 Jan 2012 20:05:48 GMT

Hi qliksus

In your example, you use a static image, so I think the original picture was moven.

I suggest to use a dynamic image/

Do like this

In the color panel, check dynamic image with the formula :

='http://maps.google.com/staticmap?center=' & num(var_mid_lat, '##############', '.', ',' ) & ',' & num(var_mid_long, '##############', '.', ',' ) & '&zoom=$(var_zoom)' & '&maptype=' & var_maptype & '&size=' & map_size_x & 'x' & map_size_y & '&key=' & gmap_key & '&.jpg'

Just copy/paste

Then set the transparency to 0%

Re: Google Maps Question

qliksus — Tue, 24 Jan 2012 05:39:20 GMT

Thanks Jean. Its working.

topic Google Maps Question in QlikView

Google Maps Question

Google Maps Question

Re: Google Maps Question

ok, but can you give me an example. I have not used the Google API. thanks

Re: Google Maps Question

Google Maps Question

Re: Google Maps Question

Re: Google Maps Question

Re: Google Maps Question

Re: Google Maps Question

ok,

but can you give me an example.

I have not used the Google API.

thanks