topic Re: GEO Coordinates in wrong format in App Development

GEO Coordinates in wrong format

ingo_lsg — Tue, 13 Aug 2019 15:55:09 GMT

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.

latitude = 149.015

longitude = 101.599

Please see also the attachment.

THX

Ingo

allorens_14 — Wed, 14 Aug 2019 08:41:37 GMT

This format works to me!

ingo_lsg — Wed, 14 Aug 2019 08:49:36 GMT

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 — Wed, 14 Aug 2019 08:53:44 GMT

Use GeoMakePoint function

In case of formatting problems use string functions (e.g. replace) for conversion.

Regards,

Thomas

If applicable mark as helpful / solved

allorens_14 — Wed, 14 Aug 2019 08:58:36 GMT

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.