topic Re: Qlik sense Map in App Development

Qlik sense Map

deepakqlikview_123 — Mon, 08 Feb 2016 08:44:54 GMT

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

Re: Qlik sense Map

paul_scotchford — Mon, 08 Feb 2016 10:06:45 GMT

Here's a site I use ...

About GeoNames

Re: Qlik sense Map

deepakqlikview_123 — Mon, 08 Feb 2016 10:40:54 GMT

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

Re: Qlik sense Map

paul_scotchford — Mon, 08 Feb 2016 20:46:17 GMT

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

Re: Qlik sense Map

Tue, 09 Feb 2016 05:39:04 GMT

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

Re: Qlik sense Map

reddy-s — Tue, 09 Feb 2016 09:42:57 GMT

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

Re: Qlik sense Map

Tue, 09 Feb 2016 11:55:28 GMT

Hi Deepak,

It will be helpful to you...

https://opendata.socrata.com/dataset/Country-List-ISO-3166-Codes-Latitude-Longitude/mnkm-8ram