topic Re: Zip code in GeoAnalytics

Zip code

Anonymous — Thu, 01 Mar 2018 22:56:11 GMT

I am trying to do a map using zip codes in Qlik Sence. Is there a way to tell the data to look at the zip as a Geo Data field for "zip"? I am only seeing the option for 4 different geo field type and zip is not one of them.

Re: Zip code

Patric_Nordstrom — Fri, 02 Mar 2018 09:34:47 GMT

Hi Lee,

Use the dropdown Layer properties->Location Options->Type->Postal Code

or add the type to the location string. =zip & ',' & countrycode & ':XPC'

Thanks,

Patric

Re: Zip code

Anonymous — Fri, 02 Mar 2018 10:59:28 GMT

Thank you! Can you help me understand where the location drop down is found in Qlik?

Lee Boyd | Vice President, Product Innovation

Fourseventy Claim Management

cell (254) 717-0262<tel:(254)%20717-0262>

Lee@470claims.com<mailto:Lee@470claims.com> | www.470claims.com<http://www.470claims.com/>

web<http://www.470claims.com/> | Twitter<http://www.twitter.com/470claims> | Facebook<http://www.facebook.com/470claims> | Linkedin<http://www.linkedin.com/company/2299943>

Re: Zip code

Anonymous — Fri, 02 Mar 2018 11:03:07 GMT

Thank You! Can you tell me where in Qlik Spencer I can find the dropdown for location services?

lee

Re: Zip code

Patric_Nordstrom — Mon, 12 Mar 2018 11:19:53 GMT

Here's an example:

Re: Zip code

MikeOBX — Tue, 16 Apr 2019 23:33:17 GMT

Hi All,

When I try and plot some simple points on the map with US zip codes, I get the error "the following locations could not be found" and it shows my zip codes, but with the 0 missing from the beginning. For example a zip code of "01234" shows as "1234".

Does QLik know how to automatically map the zip codes against its default map? Or do I have to do something else?

Any help would be greatly appreciated!

Mike

Re: Zip code

Patric_Nordstrom — Sun, 28 Apr 2019 08:01:07 GMT

If the indata contains leading zeroes, you can force Qlik to treat the field when loading the data:

text(fieldname) as fieldname

https://community.qlik.com/t5/QlikView-Scripting/Qlikviews-handling-of-Strings-as-numbers/td-p/437109

if not you can pad with leading zeroes and stick as numerice field:

num(fieldname,'00000') as fieldname

https://community.qlik.com/t5/QlikView-App-Development/How-to-add-leading-zero-s-and-make-sure-all-the-values-have/td-p/218687

Thanks,
Patric

Re: Zip code

mss — Thu, 25 Jul 2019 16:18:43 GMT

Hi Patric,

I'm trying to plot an area map for Europe, but Qlik Sense only recognize France/Germany/Spain zip codes, and cannot recognize other countries like Austria or UK.

Is there any specific format in the database I should follow for plotting different countries?

Thanks!

Re: Zip code

Patric_Nordstrom — Mon, 29 Jul 2019 09:43:16 GMT

There is no universal standard for postal codes, each country has their quirks.

I recommend this post for tips to improve

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/How-to-improve-the-lookup-accuracy/ta-p/1553461

UK is especially special, see this thread:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Association-of-maps-with-postal-code/td-p/59109

Thanks,

Patric

Re: Zip code

rpages — Thu, 19 Sep 2019 13:22:07 GMT

Hi @Patric_Nordstrom

I've read all your posts but I still have an issue.

In France we have some oversea territories that do not work on qlik.

I have used their country code ('RE', 'GP','GF','MQ,...) but qlik do not recognise their postal code : 97100, 97200,...

Do you have a solution?

Thank you

rémi

Re: Zip code

Patric_Nordstrom — Thu, 19 Sep 2019 13:28:39 GMT

Yes, that's correct, overseas zips are not included (same for the US), I should mention that in the coverage docs.

If you find a source for the overseas areas they can be loaded in to Sense separately.

Thanks,

Patric