Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dradoikov
Partner - Contributor III
Partner - Contributor III

Google Maps Question

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

8 Replies
Not applicable

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
Partner - Contributor III
Partner - Contributor III
Author

ok,
but can you give me an example.

I have not used the Google API.

thanks

Not applicable

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

Not applicable

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

Not applicable

The link is broken Sri

JJ

qliksus
Specialist II
Specialist II

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

Not applicable

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
Specialist II
Specialist II

Thanks Jean. Its working.