Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

josephinetedesc
Contributor III

is there a source of postcodes in Australia with Longitudes and Latitudes?

Hi All

I am a newbie in QlikSense.

I have made a map visualisation using postcodes in Australia.

I am using a spreadsheet - found below, but I needed to do a number of fixes:

Australian Postal Codes - Matthew Proctor

Q1  Is there a better resource - because this particular resource (and I am grateful I found it) does not have a 1 to 1 relationship between postcode and longitude/latitude.

Q2.  In the real world - is this how would I proceed? 

a. publish the QlikSense to the ?cloud or the ?Enterpise browser (i have not gto to this part of the book yet!)

b. give the browser address to a user

I must admit though - doing a map visualisation was fairly easy once I had prepared the spreadsheets.

Jo

2 Replies

Re: is there a source of postcodes in Australia with Longitudes and Latitudes?

josephinetedesc
Contributor III

Re: is there a source of postcodes in Australia with Longitudes and Latitudes?

Hi Gysbert

I did not use a KML file.  I did a vlookup in Excel for the postcodes to get their lats and longs.  Qliksense then "worked".  My original problem was the file that I originally had was not one to one ie one postcode for one lat/long pair.

Jo