Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ingo_lsg
Contributor III
Contributor III

GEO Coordinates in wrong format

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

4 Replies
allorens_14
Contributor II
Contributor II

This format works to me!

Captura.PNG

ingo_lsg
Contributor III
Contributor III
Author

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
Partner - Creator III
Partner - Creator III

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
Contributor II
Contributor II

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.