topic Re: Qlik Sense geo mapping - unable to add coordinates in App Development

Qlik Sense geo mapping - unable to add coordinates

Fri, 16 Oct 2015 00:15:08 GMT

I am using Qlik Sense server.

I have set up my GeoKey using geomakepoint():

GeoMakePoint(GeoMap.Latitude, GeoMap.Longitude) as GeoKey

However, I am unable to select the GeoKey when I create the map:

Any help would be appreciated.

Re: Qlik Sense geo mapping - unable to add coordinates

Michael_Tarallo — Fri, 16 Oct 2015 20:01:34 GMT

Hello Andrew - this could be a few things.

What version of Qlik Sense are you using?
The reason I ask, with 2.1 we added the ability to allow GeoMakePoint to work within the Master Items Dimensions. Sometimes people do this with an older version in which it does not work - it must be done in the load script.
Are you using GeoMakePoint in the script?
Can you view your key field using the Data Model Viewer and see if it tagged like this: $geopoint

Can you try this sample data attached and let me know if it works for you. (orders and Customers and Categories)

Can you attach your sample data as well - there may be a formatting issue with the Lat and Long,

Let's try these things first and we can take it from there.

note sure if you saw these videos either, but they may help as well: Using the Maps Chart Object - Points Maps - Part 1 - (video)

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Qlik Sense geo mapping - unable to add coordinates

Sun, 18 Oct 2015 23:05:38 GMT

Michael, thanks for your response.

I found out what the issue was...

In my load script, I have the following line:

If( GeoMap.Latitude = 0 and GeoMap.Longitude = 0 , null(), GeoMakePoint(GeoMap.Latitude, GeoMap.Longitude)) as GeoKey

I did this because I have data without coordinates, and I want to hide this rather than show it it as [0 , 0] on the map. However, this doesn't recognise the field as a $geopoint, but as $text.

My workaround:

1. Change the load scrip to:

GeoMakePoint(GeoMap.Latitude, GeoMap.Longitude) as GeoKey

2. Set up the map visualisation using GeoKey (which is now recognised)

3. Reload the data with the original script:

If( GeoMap.Latitude = 0 and GeoMap.Longitude = 0 , null(), GeoMakePoint(GeoMap.Latitude, GeoMap.Longitude)) as GeoKey

This resolves the issue and allows me to hide null() coordinates.

Re: Qlik Sense geo mapping - unable to add coordinates

Michael_Tarallo — Tue, 20 Oct 2015 12:34:52 GMT

Hi Andrew --- great to hear, thanks for the update. Stay in touch with us and let us know how you do. we are here to help.

Regards,

Mike T

Qlik