Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Find latitude and longitude from address

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

5 Replies
Highlighted
Partner
Partner

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.

Highlighted
Partner
Partner

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.

Highlighted
Not applicable

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

Highlighted
Partner
Partner

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;

Highlighted
Not applicable

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.