Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dradoikov
Partner - Contributor III
Partner - Contributor III

QlikView Google Maps work with Address

Hi,

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


Regards

1 Solution

Accepted Solutions
dirk_konings
Creator III
Creator III

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.

View solution in original post

2 Replies
dirk_konings
Creator III
Creator III

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.