Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelLerch
Contributor
Contributor

Missing spots in Map

Dear All,

I created a map layer dissolved by 3 digits of the German Postleitzahl (ZIP code).

As not all Zip Codes are present in the data there are some missing spots in the area layer ( see pictures below).

Is there any chance to remove the missing spots?

Thanks in advance.

Michael

Labels (4)
1 Reply
marcus_sommer

You may populate the missing ones - maybe with a logic like:

concatenate(Facts)
load ZipCodeDimension as ZipCode, 0 as Value resident ZipCodeDimension
where not exists(ZipCode, ZipCodeDimension);

You may need some more efforts to include further relations, for example for a period-field or any category or similar. This would require to create a suitable population-table before the above shown exists-logic is applied.

This method is not particular for geo-information else a general approach of creating non exists data to make them visible and accessible within the UI.