Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
PFA.
I have attached countries that are available in data model
.
I need to create a chart in qliksense but for that pupose need longitude and latitude information for each country.
Can you please suggest how to get longitude and latitude information.
Thanks
Here's a site I use ...
Hi Paul,
thanks for the response.You mean I need to copy and paste longitude and latitude values manually for each country. Please suggest.
Thanks
Hi Deepak,
The site I mentioned above provides some free mapping data, but if you google you will come up with some other providers of free map data.
You will need to obtain a list of countries that have the Lat/Long and import these into your app into a table e.g. Location, simple structure to get you started would be Country, Lat, Long, but you need to use GeoMakePoint() to
convert the lat/long to something you can use on a map e.g. GeoMakePoint(Latitude,Longitude) as GeoKey.
You could also use KML files too.
Hope this helps.
Paul
Hi Deepak,
Here is a link where you will get the names of the 'Countries', 'Latitudes' and 'Longitudes' with the 'Country Code'.
Create a new .csv file from the above data and JOIN this 'Countries' field with the country field in your database.
If the name matches, you will get the latitudes and longitudes of all countries available.
No need to enter Latitude and Longitude for each country separately.
Regards,
Rohan
Hi Deepak,
You can display a Map in QlikSense in 2 ways.
Using Lat and Long: You can get the latitude and longitude from the web. Once we have the info we can use the geoMakePoint(Lat,Long) to create a point. this will plot the points on the map.
Using a Polygon: You need the polygon information which also be extracted from the web(a KML file with path information). This produces a polygon map with boundaries.
Thanks,
Sangram
Hi Deepak,
It will be helpful to you...
https://opendata.socrata.com/dataset/Country-List-ISO-3166-Codes-Latitude-Longitude/mnkm-8ram