Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
visualssinziana
New Contributor III

Map Object Display City Issue

I have name of the cities and geo coordinates in my data (longitude and latitude) and I want to display organizations by cities on the map.

I created a GeoMakePoint() from longitude and latitude and the data field seems ok and corresponds to a city correctly (see the table object from the picture below). But when I try to plot the coordinates on the map object all my points are distributed chaotically and mostly in Antarctica . I don't think Qlik sees the coordinates correctly somehow.

I checked the coordinates for the cities with an external source and they are correct.

Map object issue.jpg

Any ideas what is the issue with my map?

Thanks,

Tags (2)
1 Solution

Accepted Solutions
Khan_Mohammed
Honored Contributor II

Re: Map Object Display City Issue

With your Data I'm getting the points on USA.

Untitled.png

And below is the script

Untitled.png

I guess in your script you used

    GeoMakePoint(sit_longitude, sit_lattitude) as Location

But you should first use Latitude and then longitude like above field Location.

View solution in original post

8 Replies
Khan_Mohammed
Honored Contributor II

Re: Map Object Display City Issue

Can you please upload the sample file for your Lat & Long to test?

Partner
Partner

Re: Map Object Display City Issue

maybe you have to replace dot with comma symbol for lat and long data.

ramshoney
Contributor

Re: Map Object Display City Issue

Try To create the GeoMakePoint() as a Master Item and use it.

Load the appropriate Map Background.

if possible share the sample data.

visualssinziana
New Contributor III

Re: Map Object Display City Issue

Hi Aehman, I attached the sample data and I added the raw columns longitude and latitude and the GeoMakePoint(Map Location) that I created with longitude and latitude. Thanks,

visualssinziana
New Contributor III

Re: Map Object Display City Issue

Hi Ramesh,

I attached the sample data and I tried the GetMakePoint() aprroach. I have the raw columns longitude and latitude and the column Map location is the result of GetMakePoint(longitude, latitude). Thanks,

visualssinziana
New Contributor III

Re: Map Object Display City Issue

I will try this. Thanks,

Khan_Mohammed
Honored Contributor II

Re: Map Object Display City Issue

With your Data I'm getting the points on USA.

Untitled.png

And below is the script

Untitled.png

I guess in your script you used

    GeoMakePoint(sit_longitude, sit_lattitude) as Location

But you should first use Latitude and then longitude like above field Location.

View solution in original post

visualssinziana
New Contributor III

Re: Map Object Display City Issue

You are right . I did used longitude and latitude when making the points. Problem solved. Thanks,