Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

alexis
Contributor III

Trouble with Point layer

Hi

I have a very simple data set comprising of a set of addresses/properties which I want to show on a map (for a real estate application).

I'm working on 2 data files:

1) Properties:

_properties.jpg

and

2) Geo-data:

_geodata.jpg

As you can see the "geo" data comprises of Latitude and Longitude sets for post codes that belong to an  "Area" that belongs to a "Town"

When I load into Qlik Sense, it recognises the towns and country and automatically generates code for mapping the towns which is not what I want - I want to show properties in the "Area" they belong and not the city. I tried creating a GeoPoint using "MakeGeoPoint" but the application seems to lose the decimal points in the latitude and longitude (35.091.320 becomes 35091320) which maps nowhere of course.

I attach the Qlik Sense qvf along with the 2 Excel files in the hope that someone can point me to the right direction.

Thank you in advance

Alexis


2 Replies
rajan_1989
New Contributor III

Re: Trouble with Point layer

In the file latitude and longitude are given as whole numbers. Also I think you can recognize a location either by post code or specifying its latitude and longitude. if you are giving the post code it will automatically recognize the location irrespective of lat,long and vice versa.

Hope that helps

Employee
Employee

Re: Trouble with Point layer

Hi Alexis,

Are you using Qlik GeoAnalytics? Unfortunately there are no zip codes built in for Cyprus but lat long will work.

The coordinates looks funny, is it perhaps degrees, minutes and seconds?

The coordinates needs to be in decimal degrees, here's how you convert:

Degrees,minutes,seconds to decimal degrees converter

Thanks,

Patric Nordström

Qlik

Community Browser