topic Step by step of how to Google Geocode my addresses? in QlikView

Step by step of how to Google Geocode my addresses?

Fri, 03 Feb 2012 13:24:21 GMT

To my fellow Qlikview users!

Hello I'm a noob and this is my first post, hope your all doing well. Although QV is amazing I'm having problems as I'm a biochemist which doesn't make this fall under my remit and I'm faced with constant hurdles But I believe I've done quite well. I've loaded data from Excel to form relations, got some list boxes etc... And managed to get Google maps on my dashboard but that’s where the problems arise.

I've scoured the community and there seems to be nothing about how I get logitutde and lattitude using 'Geocode?' Posts I've seen show others using Google geocode but their attachments and comments just show the end results with no method included. I've got a hutch that I have to copy some txt from the Google geocode website, add to my script, reload and somehow it just happens? Help please!

Also if anyone could also tell me why only one slider works as I can only zoom in out, and stuck looking at Germany, that would be grand.

Thanks In advance to any comments.

Best, Jake

Re: Step by step of how to Google Geocode my addresses?

Fri, 03 Feb 2012 20:35:11 GMT

Hi Jake

I built few month a geocode tools inside QlikView using Google Maps Geocode Api.

Please look at the attachment;

You need a little effort to adapt to your address before to call the API.

You have also in the share section a good example

http://community.qlik.com/qlikviews/1124

notice that google maps is not very accurate and you are limited in the number of address.

Hope that help

Regards

Re: Step by step of how to Google Geocode my addresses?

Tue, 07 Feb 2012 14:09:17 GMT

Many Thanks Jean-Jacques it's a start in the right direction.

Best,

Jake

Step by step of how to Google Geocode my addresses?

Thu, 24 May 2012 15:55:56 GMT

thanks..it was great

Re: Step by step of how to Google Geocode my addresses?

alan_richmond — Fri, 03 Feb 2017 00:02:19 GMT

Thats great Jean-Jaques

Do you have a version that uses the latest google API?

Regards,

Alan