How to display unknown Countries in a specific point in Qlik Sense MAP

[tommyl]

Hello experts,

Could you please help me with the below case:

I have a data with "Country Name - Region- Member" fields.

I want to show member percentage in the MAP. But the data with "no Country Information" cannot be seen (attachment: "howToshowEmptyOnesInASpecificLL.jpg")

or

When i set these empty ones as "UNKNOWN" it is shown in the map as a point that is undesired. (attachment: membersWithUnknownCountryInfo.jpg)

What is the need:

Is there a way to show these empty ones in the map, with a specific longitude and latitude values such as ( 40.691939, 28.314117 ) ll value?

Regards,

[JordyWegman · Accepted solution]

Hi Tommy,

You can create a mapping table based on your region codes with LAT/LONG.

MapLatLong2Region:
Load * Inline [
Region, LatLong
USA, ( 40.691939, 28.314117 )
];

Then use this mapping table in your script with the following formula:

ApplyMap('MapLatLong2Region',Region, [FillHereYourOwnSpecialLatLong]) as LatLong

Jordy

Climber