Discussion Board for collaboration related to QlikView App Development.
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.
'$(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.
View solution in original post