Google Maps Question

[dradoikov]

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

[#2]

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

[dradoikov]

ok,

but can you give me an example.

I have not used the Google API.

thanks

[#4]

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

JJ

[#5]

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

[#6]

The link is broken Sri

JJ

[qliksus]

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???

[#8]

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%

JJ

[qliksus]

Thanks Jean. Its working.