Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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,

1 Solution

Accepted Solutions
MK9885
Master II
Master II

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
MK9885
Master II
Master II

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

agigliotti
Partner - Champion
Partner - Champion

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

Anonymous
Not applicable
Author

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

Load the appropriate Map Background.

if possible share the sample data.

Anonymous
Not applicable
Author

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,

Anonymous
Not applicable
Author

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,

Anonymous
Not applicable
Author

I will try this. Thanks,

MK9885
Master II
Master II

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.

Anonymous
Not applicable
Author

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