GEO Coordinates in wrong format

[ingo_lsg]

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

[allorens_14]

This format works to me!

[ingo_lsg]

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:

lon

XXX.XXX

lat

XXX.XXX

[thkarner]

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

[allorens_14]

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.