Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Marv0Mat
Contributor II
Contributor II

How to use GeoMakePoint

Hey all,

at first, i'm new to Qlik so i'm learning by doing.

I want to make a map with GNSS Locations, so i have read i need to use GeoMakePoint(lat, lon). But in my table i have a combination of both like: "52.37787114683906, 9.74037411839534". I have looked into the syntax of GeoMakePoint but it can only take a split of this values. Is there an easy way to split the Value first into lat and lon?

Thanks for helping

Labels (3)
1 Solution

Accepted Solutions
Marv0Mat
Contributor II
Contributor II
Author

Hey again,

i got it myself. I cutted the String at ', ' into lon and lat. Also i replaced the '.' with a ',':

Replace(SubField(Location, ', ',1),'.',',') as lat,
Replace(SubField(Location, ', ',-1),'.',',') as lon

View solution in original post

1 Reply
Marv0Mat
Contributor II
Contributor II
Author

Hey again,

i got it myself. I cutted the String at ', ' into lon and lat. Also i replaced the '.' with a ',':

Replace(SubField(Location, ', ',1),'.',',') as lat,
Replace(SubField(Location, ', ',-1),'.',',') as lon