If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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
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.
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,
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:
So no worries and paste than function in,
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
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.
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