topic Re: Longitude and latitude question in QlikView

Longitude and latitude question

Mon, 26 Jan 2026 16:26:21 GMT

I have a question for everyone.....

I have on mi source files suppliers, customers and carriers, obviusly with their addresses and zip code, Is there any way to get lattitude and longitude of their locationes with their addresses and zip codes? I´d like to show it in the main app in a map.

So if the user enters another customers, suppliers or shippers, automatically obtain the Longitude and Latitude.

If there´s an example around the community would br great.

Cheers

Nelson Villarreal

Re: Longitude and latitude question

salto — Mon, 16 Dec 2013 15:23:00 GMT

Hi Nelson,

look for "batch geocoding" in google. It will take you to a web page that will convert your addresses to latitude and longitudes.

Hope this helps-

Re: Longitude and latitude question

Mon, 16 Dec 2013 15:54:35 GMT

Hi Sato,

Do u know if i can do that within the script in the transformation step? I think that the user wouldn´t like to do that in order to get latitude and longitude. I was thinking, when the user enter the address, QlikView would get the lat and long and show it in the map.

Cheers

Nelson Villarreal

Re: Longitude and latitude question

salto — Mon, 16 Dec 2013 16:01:43 GMT

Very interesting and nice request...but I am afraid I do not know the way to do that directly.

Re: Longitude and latitude question

Mon, 16 Dec 2013 16:07:26 GMT

Sato,

Yeah, automation is the deal, hehehehehe, I´ll keep researching this pointand I´ll keep you posted. But, the tip that u gave me was awesome, very usefull.

Thanks a lot

Nelson Villarreal

Re: Re: Longitude and latitude question

Alexander_Thor — Fri, 20 Dec 2013 22:08:11 GMT

There is no such thing as a free lunch
But here is an example that will pass along addresses to Google and gets coordinates back in return.

It contains a tiny macro which will do the url encoding for you so keep that in mind.

There is a limit on how many addresses you can Geocode a day and you should probably purchase a more reasonable quota from Google if this is a common occurrence.

Re: Longitude and latitude question

Fri, 20 Dec 2013 22:10:28 GMT

Alexander,

Thanks a lot for it, I got it already and made the translation to spanish for some others who would need it.

Cheers

Nelson Villarreal