load postal code into map

[Anonymous]

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,

[prieper]

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]

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

[fred_s]

Hi Joe,

To get you started.. see attachment

I'll have a closer look.

Grtz Fred

[fred_s]

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

[Anonymous]

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]

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]

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]

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]

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