Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III

Map Chart - Continent

Hi - Without using "Geo Analytics" - is there a way to have an area layer (continent) then either an area layer or a point layer for country ? How does the Map Chart (non Gel Analytics) recognize continents ?   I have seen the Country (area layer) to City (point layer) relationship, but I would like to have a Continent to Country relationship.

Any thoughts - Jerry

1 Solution

Accepted Solutions
rbartley
Specialist II

Hi Jerry,

As you say, Qlik's native map does not appear to recognize continents (which is rather odd).  The closest I could get was this:

rbartley_0-1636114416437.png

 

First, I loaded some dummy data for countries in Europe and Africa: 

[GeoData]:
Load * InLine  [
Country, Continent, Value, ContinentValue
Belgium, Europe,1,21
France, Europe,2,21
Germany, Europe,3,21
Denmark, Europe,4,21
Italy, Europe,5,21
Spain, Europe,6,21
Morocco, Africa, 7,15
Algeria, Africa, 8,15
];

Then I added a standard point layer based on the Country field, where the size and colour of the points is defined by Sum(Value).

Next, I added an area layer, again based on the Country field, but where the colouring is based on the field Continent and with the tooltip Sum(ContinentValue).  This has the disadvantage of the Continent value not reacting to selections of individual countries, so it depends on what your requirement is.

I know that you can load your own kml data, which allows for the Continent keyword: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Map/load-... , so perhaps that would provide a more complete solution.  In the meantime, I 've attached the app, in case it's useful.

 

View solution in original post

1 Reply
rbartley
Specialist II

Hi Jerry,

As you say, Qlik's native map does not appear to recognize continents (which is rather odd).  The closest I could get was this:

rbartley_0-1636114416437.png

 

First, I loaded some dummy data for countries in Europe and Africa: 

[GeoData]:
Load * InLine  [
Country, Continent, Value, ContinentValue
Belgium, Europe,1,21
France, Europe,2,21
Germany, Europe,3,21
Denmark, Europe,4,21
Italy, Europe,5,21
Spain, Europe,6,21
Morocco, Africa, 7,15
Algeria, Africa, 8,15
];

Then I added a standard point layer based on the Country field, where the size and colour of the points is defined by Sum(Value).

Next, I added an area layer, again based on the Country field, but where the colouring is based on the field Continent and with the tooltip Sum(ContinentValue).  This has the disadvantage of the Continent value not reacting to selections of individual countries, so it depends on what your requirement is.

I know that you can load your own kml data, which allows for the Continent keyword: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Map/load-... , so perhaps that would provide a more complete solution.  In the meantime, I 've attached the app, in case it's useful.