Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Qlik sense Map

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

6 Replies
paul_scotchford
Specialist
Specialist

Here's a site I use ...

About GeoNames

deepakqlikview_123
Specialist
Specialist
Author

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

paul_scotchford
Specialist
Specialist

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

Not applicable

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

reddy-s
Master II
Master II

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

Not applicable