Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can QlikView Google Maps to work on a given address rather than longitude and latitude?
Regards
you could get the longitude an latitude from maps.google self.
example :
LOAD
'$(C)' as Address1,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS Latitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS Longitude
FROM [http://maps.google.com/maps/geo?q=$(C)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);
Where XXYYZZ should be your own key (get it from google.com)
Note : only for a few records, need a payed account for a whole db.
you could get the longitude an latitude from maps.google self.
example :
LOAD
'$(C)' as Address1,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS Latitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS Longitude
FROM [http://maps.google.com/maps/geo?q=$(C)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);
Where XXYYZZ should be your own key (get it from google.com)
Note : only for a few records, need a payed account for a whole db.