Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
phaneendra_kunc
Valued Contributor III

Re: Find latitude and longitude from address

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.

ift_isabelle
Contributor II

Re: Find latitude and longitude from address

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.

Not applicable

Re: Find latitude and longitude from address

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

antose
Contributor II

Re: Find latitude and longitude from address

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;

Not applicable

Re: Find latitude and longitude from address

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.