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: 
AG-gugelbisolutions
Creator II
Creator II

Switzerland Region Map

Hi there, I need some help as I'm not able to get a very simple map to work. It is not my first map, and I can say I managed some complex ones, but this is driving me crazy.

I created an inline table containing codes and names of the 7 Switzerland regions. Codes and names should be the official ones. I also added a simple Sales field to show some data. I then created a map with a single area layer based on regions codes, but Qlik Sense keeps saying it is not able to resolve any of these.

How does Qlik Sense expect them to look like?

 

Thanks

Labels (2)
2 Solutions

Accepted Solutions
AG-gugelbisolutions
Creator II
Creator II
Author

Thanks to especially @mikaelsc, I finally got it right.

Basically I followed these steps:

  1. Download the kmz representing cantons from here  
  2. Convert the kmz to kml (I used this online service https://mygeodata.cloud/converter/kmz-to-kml)
  3. Prepare a map between cantons codes (which in this file looks like p1, p2, ...) and Region Name (taking advantage of Wikipedia)
  4. Import the kml within Qlik Sense adding Region Name by means of apply map
  5. Group by using GeoAggrGeometry function

I'm attaching an example.

  1.  

View solution in original post

8 Replies
mikaelsc
Specialist
Specialist

https://gadm.org/download_country_v3.html (use the kml/kmz files... and load them in your app)

AG-gugelbisolutions
Creator II
Creator II
Author

Thank you @mikaelsc , but I just realize that what I am looking for are the so called statistical regions (https://en.wikipedia.org/wiki/NUTS_statistical_regions_of_Switzerland)

Thanks to your link I was able to find cantons map, but not regions (which are an aggregation of cantons).

Have a nice day

AG-gugelbisolutions
Creator II
Creator II
Author

Thank you, it sounds good and I'll let you know

AG-gugelbisolutions
Creator II
Creator II
Author

Nevertheless, I would like to know why the "automatic" functionality is not working. Is that because regions are not considered in the "Qlik geographical dataset", or is it because I'm doing something wrong?

More in general, is it possibile to have a look to the dataset that Qlik holds in its system that match Administrative Level 1, 2, ... and so on ?

Thanks

 

 

Steven_Haught
Creator III
Creator III

@AG-gugelbisolutions 

Here is a link to Patric break out of coverage for the maps. The attached PDF in that post will tell you about coverage for each country. 

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Qlik-GeoAnalytics-Coverage/ta-p/1479148

As mentioned in this same post, you can use the Load operator in the GeoAnalytics to retrieve all info for a country.

AG-gugelbisolutions
Creator II
Creator II
Author

A quick update: it seems like Switzerland Administrative Level 1 corresponds to Cantons rather than Regions...

AG-gugelbisolutions
Creator II
Creator II
Author

Thanks to especially @mikaelsc, I finally got it right.

Basically I followed these steps:

  1. Download the kmz representing cantons from here  
  2. Convert the kmz to kml (I used this online service https://mygeodata.cloud/converter/kmz-to-kml)
  3. Prepare a map between cantons codes (which in this file looks like p1, p2, ...) and Region Name (taking advantage of Wikipedia)
  4. Import the kml within Qlik Sense adding Region Name by means of apply map
  5. Group by using GeoAggrGeometry function

I'm attaching an example.

  1.