QlikView Google Maps work with Address

[dradoikov]

Hi,

Can QlikView Google Maps to work on a given address rather than longitude and latitude?


Regards

[dirk_konings · Accepted solution]

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.

[dirk_konings]

http://community.qlik.com/media/p/75131.aspx