Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

World Mapping File For Qlik Sense Maps (KML Shape and Point)

Employee
Employee

World Mapping File For Qlik Sense Maps (KML Shape and Point)

When building mapping visualizations in Qlik Sense, you will need either Lat & Long data to plot points on a map, or shape data to plot areas. For the latter, Qlik Sense will recognize KML files as a data format and load those natively. But shapes are merely a series of lat & long points that when plotted will connect up into a shape, such as a state or a sales region. When multiple shapes are plotted they can connect to form a country, or even a map of the world.

When plotting either points on a map or a series of shapes, you will need either the relevant Lat and Long data or shape data in your data model. It must also be associated the relevant field in your data model to allow you to plot the relationships. For example, to plot a series of bubbles on a world map to indicate population, you will need lat & long data for each country and you will need it linked to your population data on say country code.

UPDATE (8/7/2017): The new mapping object in Qlik Sense allows you to render maps without actually having the shape or point data in your data model. This is because the map object leverages a geospatial engine that recognizes country, state and town names dynamically. For more information refer to our help: https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Visualizations/Map/Map.htm

But where can you get such a data set? Well, there are many free location based data sets on the web, but often they are a bit fragmented and incomplete. To save you all a bit of time I have joined together a few files into a single world based location set, which contains the following for each country:

- Latitude & Longitude

- Country Shape data

- 2 char ISO code

- 3 char ISO code

- Short Name

- Full ISO Name

These are contained in the attached QVD file which I hope you find useful. When I get a chance I will also upload a Qlik Sense app with a few examples using the data. If you need some info on how to use the mapping object check out this great video from Mike TaralloQlik Sense - Creating a Map Visualization

Shape_map.png

Attachments
Comments
flanfranco
New Contributor III

Great post!!
Thanks!

Not applicable

The best world map data I've found so far.  One reminder, as I forgot after loading this qvd...don't forget the Tag syntax in your script, ie...

Tag field WorldCountries.ShortName with $geoname;

Tag field WorldCountries.Point with $geopoint;

Tag field WorldCountries.Area with $geomultipolygon;

ekech_infomotio
Contributor II

Great work - thanks a lot!

There is only one little thing: it seems Taiwan is missing...

Employee
Employee

Its controversial, but one of the data sets that I combined had Taiwan as part of Greater China. So I think that's where it ended up.

davidganly
New Contributor III

One small step for one man = one giant leap for others.  Thank you

karthiksrqv
Contributor II

Thanks Lee for the article!

When we started by using your KML file, we found the map to be a bit slow.

I tried to simplify the country boundaries. Here are a few sites that helped:

thematicmapping.org

http://support.esri.com/technical-article/000012399

http://www.mapshaper.org/

http://www.mapsdata.co.uk/online-file-converter/

Hope this helps!

-Regards.

Not applicable

Hi Lee

Do you have any idea how I could group geopoints by kml boundary? What I have is a bucket load of latitude and longitude points, but no location details. I want to group these points into their appropriate countries.

Employee
Employee

Hi Richard

I looked into that for a customer recently. There is no function within Qlik to work out which geo-boundary the points fall into. You would have to use a third party system to work out the country associations, or use a mapping extension that can can do it. Possibly MapInfo could do that.

lefzam00
New Contributor II

Great post! One minor thing. Lebanon and Botswana are overlapping. Is there a way to fix that?

Thanks!

Employee
Employee

That is odd. Yes, you can edit the KML manually in a text editor (which is pretty awkward) or you could potentially use an online tool to get the correct shape of the offending country and then paste that over the relevant node in the file. (If only geopolitical solutions were that easy).

Version history
Revision #:
1 of 1
Last update:
‎07-01-2015 09:28 PM
Updated by:
Employee