Luxembourg ZIP Codes

[Kafka_polka_dot]

Hi dear members of Qlik community,

I have an issue with Qlik map: the ZIP codes from Luxembourg are not shown on the map.

If I create an Area map, add zip codes as 'Standort', I don't see any objects.

If I create a point layer, only one point is reflected, having 'L-' prefix.

Could you please help me to understand, what is wrong with the map? I tried to convert all the zip codes to integers, format them to have 'L-' prefix, nothing helped so far.

[justISO]

Hi, I believe Luxembourg is a country which in Qlik have only 2 digits postal code areas which usually correspond to some level administrative boundaries.Try instead of 'plz' use left([plz],2). Additionally, you can try to convert plz to integer by num(plz, '0000') to fill some missing digits.

[Kafka_polka_dot]

Hi JustISO,

thanks for your reply! I have followed your suggestions an unfortunately still did not get the correct result:

1. If I set zip codes as left([plz],2), both oint and area maps show only part of the addresses, missing the majority of them.

2. If I convert the plz to integer by num(plz, '0000'), there is nothing shown on the map.

Are there any official documentation references for the way Luxembourg addresses are processed in Qlik?

[justISO]

Maybe you can find some usefull insights in forum post, like this?:
https://community.qlik.com/t5/Qlik-Sense-Documents/Mapping-Postal-codes/ta-p/1586891 and related https://community.qlik.com/t5/Qlik-Sense-Documents/Mapping-Postal-codes/ta-p/1586891
or about missing zip codes areas: https://community.qlik.com/t5/App-Development/Qlik-Sense-Map-Chart-Area-Layer-Missing-Zip-Codes/td-p...