Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have a file including latitude and longitude in a wrong format.
How can I get that in the correct format so that Qlik recognizes it as geo coordinates.
EX
latitude = 149.015
longitude = 101.599
Please see also the attachment.
THX
Ingo
This format works to me!
Dear Allorens,
I don't understand and not agree to your answer.
You have the format:
lon
X,XXXXXXXXXXXXXXX
lat
XX,XXXXXXXXX
But I have the format:
XXX.XXX
Use GeoMakePoint function
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/GeospatialFunc...
In case of formatting problems use string functions (e.g. replace) for conversion.
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunction...
Regards,
Thomas
If applicable mark as helpful / solved
Hello,
Your lat and lon are indeed in a wrong format. Seems like they come from some proyection not using WGS84.
For change the proyection in QS the only way is using GeoAnalytics.
