Discussion Board for collaboration on QlikView Scripting.
Is there a quick way to get co-ordinates (X and Y) of cities if you just have city names?
E.g. I have a table with a list of city names. And I would like to get the X and Y co-ordinates of those cities without having to manually look for it and populate it in some spreadsheet.
Yes this is possible, but you need to have geolocation service providing you with a data file that will contain the needed elements such:
City, Country, Longitude, Latitude, .....
Check on qlikmarket, google, openstreetmap, maxmind, geonames....
Short Review of Geographic Mapping Options in QlikView
X, Y? Map locations are expressed in polar rather than Cartesian coordinates
Table: LOAD City FROM Table; let noRows = NoOfRows('Table')-1; for i=0 to $(noRows) let b = peek('City',$(i),'Table'); GeocodeResponse: LOAD status, '$(b)' as CustomerCity, ([result/geometry/location/lat]) as latitude, ([result/geometry/location/lng]) as longitude FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse]); next i;
google maps coordinates lookup issue
Maps using address info not coordinates
Re: Step by step of how to Google Geocode my addresses?
getting Long. & Lat. coordinates