Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

load postal code into map

I have each store's postal code (NO longitude/latitude) with sales, want to load them into map to show where the best locations are.

What's the easiest way to implement them on a map? Thanks,

11 Replies
prieper
Master II
Master II

Which country?

Think that you will need a kind of mapping table to link a postal code to geo-data in order to present in e.g. Google Maps.

Have you googled to:

http://download.geonames.org/export/zip/

already?

Peter

Anonymous
Not applicable
Author

Sorry for not being clear, I need USA and Canada.

fred_s
Partner - Creator III
Partner - Creator III

Hi Joe,

To get you started.. see attachment

I'll have a closer look.

Grtz Fred

fred_s
Partner - Creator III
Partner - Creator III

I believe this should get you going..

A couple of things to remember/check..

My script variables are western Europe settings (first tab in QV script), means things can be (/will be) different in your country (seperators, monthnames etc)

The Postalcode I use to link locations to customers/stores is something like US-80302 or CA-M5H.

It's countrycode (US/CA) plus for US the numeric part, for Canada the first 3 characters.

Countrycode and Postal are concatenated in the script, so you can use address-data like I did in my script:

    Debno, Name, Address, Postcode, City, Country

    5, Google On, 12th Floor 111 Richmond Street West, M5H 2G4, Toronto, CA

    6, Google Ch, 20 West Kinzie St., IL 60654, Chicago, US

   

You can use the slider to zoom.

You can't drag the map.

Have fun 🙂

Btw If your question is answered, please mark it as answered..

maps-usca.JPG

Anonymous
Not applicable
Author

Hello, Fred, Thanks for your work and explanation.

Unfortunately I am using Personal Edition,could not open the file. Is that anyway to walk around? thanks.

fred_s
Partner - Creator III
Partner - Creator III

Step by step?

1. First lets see if you can get a working Google maps in your PE.

In the folder C:\Program Files\QlikView\Examples\Documents

open the document "Whats New in QlikView11.qvw" and go to tab Customer.

Or have a look in the other example files.

2. Save my file I've posted earlier, US-CA.txt

These are the Postcodes you're going to use to link to your postal codes.

Anonymous
Not applicable
Author

Hello, Fred, Just back from a off site business trip. Sorry for late reply.

I have checked what's new sample, the google map works there. Your txt file has been saved well.

what's the next step? Thanks.

fred_s
Partner - Creator III
Partner - Creator III

The easiest way is to share a part of your data, a couple of your stores, some in the states and some Canadians.

I will create your script and you can copy this script in your Qlikview file later.

Anonymous
Not applicable
Author

Hello, Fred, please find the attached excel file, thanks.