Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using qlikmap to show data on map..I have 3 columns in my excel file zipcode,town and country.is it possible in qlickview to read them and convert to longitude and latitude so that I can show them on map.Or do I have to create columns in excel for latitude and longitude and read them in qlickview,Thanks very much
Qlik dont have a GeoCoding capbilities. Menaing it can not pasrse the address/city-zip and convert to Lat & Long.
You have to add the lat & long in excel/data source and read it into qlik.
There are online sources where you can get the lat & long at zip,city & country level. Download that and use.
I heard of a possibility to get the Latitude and Longtude from Google Maps API.
Haven't tried it myself, we bought a file with zipcodes and Lat en Lon.
Hi Adil,
Yes Phaneendra is right you have to add it to your raw data manually, what I can suggest you , download any source table which has Lat and Long values for city and apply vlookup , So you donot need to add values for every record manually.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Rohit Kumar
Hi!
You can try to loop over the address and call the Google API.
...
...
Address:
LOAD '$(vID)' AS ID,
[result/geometry/location/lat] as lat,
[result/geometry/location/lng] as lng,
status
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(vAddress)] (XmlSimple, Table is [GeocodeResponse]);
NEXT i;
Thanks . Actually I dont have any idea about source table and how it will be used.Do you know any service for excel that will convert address to latitude and longitudes. I have thousands of records.