Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

kevinpintokpa
Contributor II

Cannot get postal code lookup to work outside the US

Hi all,

I have started to work with postal codes in Qlik GeoAnalytics 5.8.1 using QlikView, but cannot get them to work outside the US.

In the US, a lookup using a composite field of Postal Code, State Code, Country Code works, e.g.

78749, TX, US

I can use this in both Bubble and Area layers.

Outside the US, I have tried several options and neither work in either Bubble or Area layers:

Canada:

H1B 5A1, QC, CA

H1B 5A1, QC, CA:XPC

H1B5A1, QC, CA

H1B5A1, QC, CA:XPC

The same results apply to any non-US country.

What does work to some degree:

Montreal, QC, CA (in the Bubble layer)

But of course, the resolution of the postal codes is lost.

Perhaps I am doing something wrong.  Any suggestions are appreciated.

3 Replies
rajan_1989
New Contributor III

Re: Cannot get postal code lookup to work outside the US

Try using named area lookup with just the pincode in the field. Select the country code in the connector popup. It worked for India in my case.

Employee
Employee

Re: Cannot get postal code lookup to work outside the US

Hi Kevin,

Zip code, country code and typ code is the prefered way: ='H1B,CA:XPC'

The coverage varies country by country, in Canada the zip code areas are of three digit resolution.

Qlik GeoAnalytics Coverage

Fr more tips on specifying locations, check out my answer here:

Re: Is there a way to pre-scrub location information for correctness?

Thanks,

Patric Nordström

Qlik

kevinpintokpa
Contributor II

Re: Cannot get postal code lookup to work outside the US

Thanks for the suggestion. Unfortunately I have a global map with over 100 countries, so I can't fix the map to just one country.

Community Browser