Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Highlighted
leemeboyd
New Contributor

Zip code

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.

6 Replies
Employee
Employee

Re: Zip code

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

leemeboyd
New Contributor

Re: Zip code

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>

leemeboyd
New Contributor

Re: Zip code

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

lee

Employee
Employee

Re: Zip code

Here's an example:

location.png

MikeOBX
New Contributor

Re: Zip code

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

 

Employee
Employee

Re: Zip code

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/43710...

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-t...

Thanks,
Patric