Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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