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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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.