Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

neil_gabin
New Contributor III

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

Tags (1)
9 Replies
Highlighted
luismadriz
Valued Contributor

Re: Load and map Australian locations

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

neil_gabin
New Contributor III

Re: Load and map Australian locations

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
Valued Contributor

Re: Load and map Australian locations

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
Valued Contributor

Re: Load and map Australian locations

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
Valued Contributor

Re: Load and map Australian locations

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

neil_gabin
New Contributor III

Re: Load and map Australian locations

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
Valued Contributor

Re: Load and map Australian locations

Thanks for that Neil,

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

Cheers,

Luis

neil_gabin
New Contributor III

Re: Load and map Australian locations

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
Valued Contributor

Re: Load and map Australian locations

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

Community Browser