topic QlikView Google Maps work with Address in QlikView

QlikView Google Maps work with Address

dradoikov — Fri, 11 Jun 2010 12:54:18 GMT

Hi,

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

Regards

dirk_konings — Mon, 14 Jun 2010 10:11:45 GMT

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 — Mon, 14 Jun 2010 10:30:09 GMT