topic Re: Switzerland Region Map in App Development

Switzerland Region Map

AG-gugelbisolutions — Sat, 16 Nov 2024 17:52:39 GMT

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

Re: Switzerland Region Map

mikaelsc — Wed, 04 Nov 2020 18:45:26 GMT

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

Re: Switzerland Region Map

AG-gugelbisolutions — Wed, 04 Nov 2020 19:17:22 GMT

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

Re: Switzerland Region Map

mikaelsc — Wed, 04 Nov 2020 19:33:01 GMT

well...aggregate them 🙂

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

Re: Switzerland Region Map

AG-gugelbisolutions — Wed, 04 Nov 2020 19:49:44 GMT

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

Re: Switzerland Region Map

AG-gugelbisolutions — Wed, 04 Nov 2020 19:55:36 GMT

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

Re: Switzerland Region Map

Steven_Haught — Wed, 04 Nov 2020 20:16:24 GMT

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

Re: Switzerland Region Map

AG-gugelbisolutions — Thu, 05 Nov 2020 09:01:58 GMT

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

Re: Switzerland Region Map

AG-gugelbisolutions — Thu, 05 Nov 2020 17:51:38 GMT

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

Basically I followed these steps:

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

I'm attaching an example.