Google Maps Integration in Qlikview

Thu, 16 Jun 2016 06:46:24 GMT

Hi All,

I am facing some issues with fetching the latitude and Longitude data from the Google API. I have made some changes to the code which was available online so that i can access the api. The code is as below. Any help is appreciated. Table1 contains data for the name and country. Thanks in advance

let noRows = NoOfRows('Table1')-1;

for i=0 to $(noRows)

let a=peek('Name',$(i),'Table1');

let address=peek('Country',$(i),'Table1');

Data:

Load

'$(a)' as Name,

'$(address)' as Address

[GeocodeResponse/result/geometry/location/lng.value] AS longitude,

[GeocodeResponse/result/geometry/location/lat.value] AS latitude

FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&output=xml&oe=utf8&sensor=false] (XmlSimple, Table is [kml]);

Re: Google Maps Integration in Qlikview

Tue, 03 Jan 2017 08:10:21 GMT

Fixed it the issue was with a variable used.

topic Google Maps Integration in Qlikview in QlikView

Google Maps Integration in Qlikview

Re: Google Maps Integration in Qlikview