Switzerland Region Map

[AG-gugelbisolutions]

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

[mikaelsc]

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

[AG-gugelbisolutions]

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

[mikaelsc · Accepted solution]

well...aggregate them 🙂

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/Geospatia...

[AG-gugelbisolutions]

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

[AG-gugelbisolutions]

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]

@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]

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

[AG-gugelbisolutions · Accepted solution]

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.