topic Re: How to extract latitude,longitude for certain country in qlikview in QlikView

How to extract latitude,longitude for certain country in qlikview

Srinivas — Fri, 12 Sep 2014 05:02:41 GMT

Hi All,

how to extract latitude and longitude for certain country by using of script, for suppose CHINA,INDIA country i want extract from Google.

Can you help on this if have sample application that would be better.

Advance Thanks

Munna

Re: How to extract latitude,longitude for certain country in qlikview

vikasmahajan — Fri, 12 Sep 2014 05:10:41 GMT

You can go this site Latitude and Longitude Finder on Map Lat Long Lookup and copy paste latitudes and longitudes state wise in excel and then load the same for google chart.

Hope this helps you.

Vikas

Re: How to extract latitude,longitude for certain country in qlikview

MarcoWedel — Fri, 12 Sep 2014 05:17:42 GMT

Country List ISO 3166 Codes Latitude Longitude | Socrata

Re: How to extract latitude,longitude for certain country in qlikview

sushil353 — Fri, 12 Sep 2014 05:21:47 GMT

Hi,

You can get it from Countries List with Place Counts

store the data in excel file and then load into qlikview.

HTH

Sushil

Re: How to extract latitude,longitude for certain country in qlikview

tresB — Fri, 12 Sep 2014 05:25:16 GMT

You could pass your country in the URL like:

Load

LOAD status,

[result/geometry/location/lat] as Latitude,

[result/geometry/location/lng] as Longitude

from [http://maps.googleapis.com/maps/api/geocode/xml?address=India&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

Note: 'address=India'

Re: How to extract latitude,longitude for certain country in qlikview

MarcoWedel — Fri, 12 Sep 2014 05:48:20 GMT

tabCountryCoords:
LOAD Country,
    [Alpha-2 code],
    [Alpha-3 code],
    [Numeric code],
    [Latitude (average)],
    [Longitude (average)]
FROM [url see attachment]
(txt, utf8, embedded labels, delimiter is ',', msq);

hope this helps

regards

Marco

Re: How to extract latitude,longitude for certain country in qlikview

senarath — Fri, 12 Sep 2014 08:56:49 GMT

Hi tresesco,

I ran your script by changing country as SriLanka. But I get Cartesian effect and looping tables in data model. Any idea or advice ?

thnx