Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
deepaktibhe
Valued Contributor

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

Re: Qlik sense Map

Here's a site I use ...

About GeoNames

deepaktibhe
Valued Contributor

Re: Qlik sense Map

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

Re: Qlik sense Map

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

Re: Qlik sense Map

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

reddys310
Honored Contributor II

Re: Qlik sense Map

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

Re: Qlik sense Map

Community Browser