Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lavrendis
New Contributor

Map not complete

Hi there,

i have create a map object in Qliksense which i find an impressive feature.

But the thing is that the map is not complete. I am not sure if this is from the country data i have or from a problem coming from the world.kml file.

If you see in the attached file Belgium, Russia and several countries from Africa are missing.

2017-06-28 17_45_54-.png

Thanks in advance for the help.

Tags (1)
1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Map not complete

Hi,

Perhaps in file KML there is no data of the missing countries. In the attached files variant of solution.

Regards,

Andrey

5 Replies
ahaahaaha
Honored Contributor

Re: Map not complete

Hi,

Perhaps in file KML there is no data of the missing countries. In the attached files variant of solution.

Regards,

Andrey

lavrendis
New Contributor

Re: Map not complete

Hi, thank you for the files.

It does the same in my application. In my script i have not changed anything. It is Qliiksense who added all necessary lines.

suppose since it is working for most of the countries it does not come form a script error.

Belgium and some others countries are missing.

Any ideas?

BR,

Lawrence

ahaahaaha
Honored Contributor

Re: Map not complete

Are the countries (Belgium etc) missing after downloading my file? In the attached file, Belgium show1.jpg

lavrendis
New Contributor

Re: Map not complete

Hi, sorry for the late answer. There is no change after installing your file. The countries are still missing including Belgium

I do not understand how it works because in the data file there are countries with their full name like France and it shows them normally but Belgium which is stated  as BE (as in the KML file) it does not show it.

Regards,

Lawrence

lavrendis
New Contributor

Re: Map not complete

Hi again,

i think i have found something important. It seems that the KML file does not  do anything in my case because everything is loaded automatically by the script as shown below.

I was loading the KML but apparently it does not function. I deleted it from the script and nothing changed.

So, i think i need help to understand what exactly i need to load in order to have the map loaded correctly.

__countryAliasesBase:

LOAD

Alias AS [__Country],

ISO3Code AS [__ISO3Code]

FROM [lib://__GEO_TABLES/countryAliases.qvd]

(qvd);

__countryGeoBase:

LOAD

ISO3Code AS [__ISO3Code],

ISO2Code AS [__ISO2Code],

Polygon AS [__Polygon]

FROM [lib://__GEO_TABLES/countryGeo.qvd]

(qvd);

__countryName2IsoThree:

MAPPING LOAD

__Country,

__ISO3Code

RESIDENT __countryAliasesBase;

__countryCodeIsoThree2Polygon:

MAPPING LOAD

__ISO3Code,

__Polygon

RESIDENT __countryGeoBase;