Qlik Sense Map Object: issue when identical values are used as dimension in Area/Bubble Layer

[Joseph_Musekura]

In Qlik Sense & QlikView, maps are used to show a geographical representation of, for example countries, states, cities etc... Maps are also used to show a geographical distribution of offices, stores, and other sites of business interest. 
An area (or bubble) layer is one of different geographical representations that can be used to represent countries, states, cities on the map. Dealing with Area (or bubble) Layer requires an understanding of data to use as  dimension in order to define the area (or bubble) and respective location on the map .

Depending on the data model, a common error occurs when there are identical values in added dimension. Consider the following simple-dummy use-case.

//In Belgium, the Municipality of  'Antwerpen' is divided into 3  “zip codes”
//While 'Antwerpen-Berchem' Municipality has 1 “zip code” 
LOAD * INLINE [
ZipCode, Municipality, Country
2000, Antwerpen, Belgium
2018, Antwerpen, Belgium
2020, Antwerpen, Belgium
2600, Antwerpen-Berchem, Belgium
];

In above use-case when using a native map, adding an area layer with "Municipality" as dimension and "ZipCode" as Location, will result in the following

• Selecting ‘Antwerpen-Berchem’ works as expected and area representing  ZipCode 2600 is displayed

• However, no area displayed on map when ‘Antwerpen’ is selected

Environment

• GeoAnalytics for Qlik Sense /QlikView

Resolution

From the above data model, a similar straight table with Municipality as dimension and =only(zip) as measure  will look like this

 In 'Area/Bubble Layer' the dimension defines the number of objects on map while the location is a measure. If you want to display zipcodes, the dimension has to be unique for zipcodes.

To solve such behavior follow this process, it is similar to dealing with cities with the same name.