Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner - Creator III
Partner - Creator III

Googleapis

Hi All,

I've a script to get the latitude and longitude out of an adress via this script:

 

LOAD
'$(k)' as %Customer,
[result/geometry/location/lat] as latitude,
[result/geometry/location/lng] as longitude
FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&key=AIzakeykeykey] (XmlSimple, Table is [GeocodeResponse]);

 

In Qlikview 11.2 it is working fine. A customer of us is using Qlikview November 2017 SR6 and it is'nt working anymore.

On my desktop I've installed the April 2019 SR1 and this is still not working.

In April 2019 SR1 I get "Cannot open file: 'https://maps.goog...

In November 2017 I get Unknown LOAD statement error 

 

Who can help me with this?

Or how do you guys create a latitude and longitude in the script?

 

regards,

Kris

1 Solution

Accepted Solutions
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Hi All,

 

I found the solution for the reload.

You can find the solution that worked for me here:

https://support.qlik.com/articles/000036107

 

Regards,

Kris

View solution in original post

1 Reply
kris_vliegen
Partner - Creator III
Partner - Creator III
Author

Hi All,

 

I found the solution for the reload.

You can find the solution that worked for me here:

https://support.qlik.com/articles/000036107

 

Regards,

Kris