Qlik Community

Qlik Sense App Development

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

Highlighted
ingo_lsg
New 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
New Contributor II

Re: GEO Coordinates in wrong format

This format works to me!

Captura.PNG

ingo_lsg
New Contributor III

Re: GEO Coordinates in wrong format

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

Partner
Partner

Re: GEO Coordinates in wrong format

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

Re: GEO Coordinates in wrong format

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.