Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LG
Contributor III
Contributor III

Map - Point layer using Zip or City & Country

Hi Community.

 

I'm using the November 2018 update.
I'm tryinng to build a "Map Chart" with a "Point Layer", which is pretty much bothering me.

Data I have (Global Data from several Countries):

  • Country (ISO 2 [US, DE, AT, CN, ...])
    • Geo data = Country code ISO2
  • Zip-Code
    • Geo data = City
    • Associated to Country
    • (No Zip-Code selection available)?
  • City
    • Geo Data = City
    • Associated to Country
  • Street
    • Geo Data = City
    • Associated to Country
    • (No Zip-Code selection available)?

 

Data I don't have:

  • Latitude & Longitude

 

What is the Problem:

1.png

  • When I use City, some Cities are shown in the wrong location (multiple city names in the same country)
  • When I use Zip Code, for example UK and China are no showing up ("wrong Zip-Code")
    • Zip CodeZip Code              CityCity

 

What is my goal:

All I want to have is a Point Layer with bubbles  in the right place.

4.png

 

What do I have to do different?

Labels (2)
11 Replies
Lauri
Specialist
Specialist

I have found it works better to set the Location Type to 'auto' and then use a country field under Country. 

LG
Contributor III
Contributor III
Author

Just tried it again, nothing has changed.

  • The "City" is still in the wrong place
  • The "Zip-Code" for China and UK are still not showing up
  • The "Country" is still in the "Country Field" below the "Location Type"
Lauri
Specialist
Specialist

Here's a picture of what I mean about the Location type, in case you didn't already try changing it.

Also, load your Vendor.PostalCode data as text so it doesn't lose leading zeroes (important in US postal codes). 

Load text(Vendor.PostalCode) as Vendor.PostalCode...

If you want to post a sample of your data I can try to create the map.

Capture.JPG

 

LG
Contributor III
Contributor III
Author

Hello Laurischarf,

Let me share some Pictures:

 

  • This is the "Point layer" I have selected, showing me the "Vendor Description (Vendor Name):
    • LayerLayer LocationLocation

 

 

 

  • Here 2 example Zip-Codes from China:
    • China Zip-CodesChina Zip-Codes
    • Nothing found in ChinaNothing found in China

 

 

 

  • Here 3 example Zip-Codes from Brazil, to show the leading 0 is there:
    • Brazil Zip-CodesBrazil Zip-Codes
    • Nothing found in BrazilNothing found in Brazil

 

 

Here the Settings for Zip-Code in the Data Table:

Data table for Zip-CodeData table for Zip-CodeData Table for Zip-CodeData Table for Zip-Code

 

Here some Example Zip-Codes, From this list, the Zip-Codes from "GB & CN"don't work:

Example Zip-CodesExample Zip-Codes

 

 

If there is anything else I could provide, please let me know.

 

Lauri
Specialist
Specialist

I think you are doing things correctly, but Qlik's location database doesn't recognize those postal codes. I loaded your examples from Shangai and Sao Paolo into my own app, along with a place in France, and only the French location appeared. At the top of the map there is a message -- see my screenshot.

Capture.JPG

Qlik provides a little help here (https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Troubleshooting/trou...).

Good luck...

LG
Contributor III
Contributor III
Author

Tried everything, still no chance to get it work...

Lauri
Specialist
Specialist

Take a look at this document:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Qlik-GeoAnalytics-Coverage/ta-p/1479148

The April 2019 attachment there talks about what countries are covered for postal codes. (I learned that it has only a few countries covered for postal code AREAS, but more countries for postal code CENTER POINTS. So it's good that you added your postal code dimension to your map as a Point layer.)

Another thing: Make sure you have valid postal codes. I went to https://worldpostalcode.com/brazil/sao-paulo and copied a few codes into my app and they showed up, but the ones I copied from your screenshot do not show up in my map.

itibook
Partner - Contributor III
Partner - Contributor III

Having a similar issue and it's frankly irritating me... did you solve it in the end?

Simple list of country code and city for major european countries

  • Area layer:  shows the countries as expected
  • Point layer: shows all the cities in mainland Europe for each country, but no points for UK cities (changed to GB country code).

This should be working out of the box, any help/suggestion very much appreciated.

 

 

LG
Contributor III
Contributor III
Author

I "solved" it with a workaround... so I'm only partially happy with the result. The GEO Function in Qlik Sense is not strong enough, you need to upgrade to Geo Analytics to get it really solved.

 

There are different ways, depending on the data you have:

1) Postal Codes have different formats behind. This is how you can solve Luxembourg for example:

=

if(Country='LU','L-' & PostalCode )  // Luxemburg postal codes starts with L-

 

 

2) or use the expression below & administrative area and watch this Video: https://community.qlik.com/t5/Qlik-Design-Blog/Qlik-Sense-Maps-Improving-Location-Accuracy-Video/ba-...

clipboard_image_1.png

 

3) Map the cities manually, example for UK:

if(Country='GB',

pick(match(City,'Brimscombe, Stroud Glos','Cheshire','Cringleford, Norwich','Essex')+1,

                     City,'Brimscombe',             'Chester', 'Cringleford',         'Chelmsford'))

 

 

You can also combine them with an =if(...

As said... Workarounds... and no satisfying solution...

 

Hope this helps.