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: 
Anonymous
Not applicable

Load and map Australian locations

Hi there

I'm using the Data Manager in Qlik Sense Cloud and trying to load some data that includes Australian cities (or suburbs).

I've included images of the Suburb table and also my Data Model Viewer.

As you can see below, the Country field is recognised as a GEO type, but the Suburb and City fields are not. I've also tried adding the coordinates as well with no success.

What am I doing wrong? I'm open to using the Data Load Editor if necessary.

2017-11-20_164710.jpg

2017-11-20_164941.jpg

10 Replies
luismadriz
Specialist
Specialist

Hi Neil,

I haven't done any mapping myself yet but I think you need to do this in your script for your Suburb table

GeoMakePoint(Latitude, Longitude) as Location

Please give a go and keep me posted

Cheers,

L

Anonymous
Not applicable
Author

Hi Luis

Yes this actually worked and my points are showing up on a local Australian map.

But, according to some of the videos I've watched, Qlik Sense 4+ should be able to read my cities and auto map them. I'm hoping to avoid having to go and collect all the coordinates for all my locations.


https://www.youtube.com/watch?v=GA7qNWElow4

Neil

luismadriz
Specialist
Specialist

You're right,

I could reproduce what's in the video shows in Qlik Cloud (No need of GeoMakePoint) but couldn't do it in QS Enterprise (June17)... weird...

I'll discuss with the QMC admin tomorrow, who knows,

Cheers,

Luis

luismadriz
Specialist
Specialist

Hi Neil,

I tried again but with a brand new app in QSE and it worked as per the video... Not sure if the problem was that the app I was trying it first had already tables loading via the load script without syncing those tables. Once you start loading via the load script. I think you just forget about Data Manager...

But any way, what Data Manager is really doing is inserting that function for you. See the script it creates:

Untitled.png

So no worries and paste than function in,

Cheers,

Luis

luismadriz
Specialist
Specialist

Hi Neil,

I thought you meant the wizard (Data Manager) doing the GeoMakePoint for you, but I think what you really want is to avoid getting coordinates... I don't think you'll be able to. In the video coordinates are present.

But I'm new to this so maybe there is some smart to getting a point provided Country, Suburb ans State. Remember that here in Australia we have many suburbs with the same name, different states of course

By the way, please let me know how you get coordinates for Australian suburbs

Cheers,

Luis

Anonymous
Not applicable
Author

Hi Luis

Yes that right. i don't mind working in the data load script at all. It is manually collecting the coordinates that is the issue.

I did find this website. Its great, but it only allows you to decode 1 location at a time.

https://www.latlong.net/

Neil

luismadriz
Specialist
Specialist

Thanks for that Neil,

When you can please remember to mark the appropriate answers as Helpful / Correct

Cheers,

Luis

Anonymous
Not applicable
Author

sure. i have done that.

Do you know if there is a way in the script to tag a field as a Geo field?

Neil

luismadriz
Specialist
Specialist

Hi, I think it's done by doing this after the load

TAG FIELDS [fieldname] WITH $geoname;

There is another Tag called $geopoint but not sure what it does.

I think I like the $geoname because it seems to place the globe icon by the field which is handy. But my knowledge is really limited on this. Haven't had any requirement for a map yet

Cheers,

Luis