Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor II
Contributor II

This format works to me!

Captura.PNG

Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

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

Highlighted
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.