topic Re: geo coordinates add calculate in QlikView

geo coordinates add calculate

Anonymous — Mon, 24 Aug 2015 14:03:23 GMT

Hi Folks,

for a distance calculation between geopoints I Need to add two latitutes

i.e.

51.0015983 + 52.6193168

I tried num and num#, but until now nothing works:-(

Please assist, for which I thank you all in advance

Wolfgang

Re: geo coordinates add calculate

Mon, 24 Aug 2015 14:12:35 GMT

Hello. I know how to find the distance between two points of latitude and longitude with and

ceil(acos(sin(Lati1)*sin(Lati2)+cos(Lati1)*cos(Lati2)*cos(longi2-longi1))/pi()*180*1.852*60))

Perhaps this formula will help.

Re: geo coordinates add calculate

marcus_sommer — Mon, 24 Aug 2015 14:20:22 GMT

In addition to SergeyKostin if your values won't be recognized as numbers you might need to convert/format them like:

num(num#(YourValue, 'Formatcode'), 'Formatcode')

- Marcus

Re: geo coordinates add calculate

Anonymous — Mon, 24 Aug 2015 15:12:10 GMT

Danke, Marcus,

aber es will mir nicht gelingen. Formel

=num(num#(Y_Lat, '#.#'), '#,#')

gibt mir keine Nummer zurück. Auch habe ich die Formatcodes aus der Hilfe strapaziert, leider ohne Erfolg.

Danke,

Wolfgang

Re: geo coordinates add calculate

Anonymous — Mon, 24 Aug 2015 15:13:55 GMT

Great!

I will try as soon as we solve the NUM - Problem.

Wolfgang

Re: geo coordinates add calculate

henrybrinkmann — Mon, 24 Aug 2015 15:18:05 GMT

Hallo,

vielleicht hilft Num(replace(Lat, '.', ','))?

Henry

Re: geo coordinates add calculate

marcus_sommer — Mon, 24 Aug 2015 15:31:43 GMT

Wenn man Komma-Trenner und Tausender-Zeichen ändern möchte, muss man alle Parameter von num#() setzen, probier mal: num(num#(51.0015983, '#.#', '.', ','))

Schöne Grüße

Marcus

Re: geo coordinates add calculate

Tue, 25 Aug 2015 06:12:21 GMT

If NUM is not working, I'm using ROUND().

Re: geo coordinates add calculate

Tue, 25 Aug 2015 06:19:57 GMT

Or try Round(num#(latitude),'0.0000001')

Re: geo coordinates add calculate

Anonymous — Tue, 25 Aug 2015 12:41:26 GMT

Great Formula,

thank you.

Wolfgang

Re: geo coordinates add calculate

Anonymous — Wed, 26 Aug 2015 13:00:25 GMT

Thanks to all Experts, I solved the 'distance-like-a-crow-flies' Problem and will start to

look behind the street distance Problem.

All of your answers were helpful.

Finally i use this formula:

=sqrt
((111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))*
(111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))+
(111.3*(lat1_c-lat2_c))*(111.3*(lat1_c-lat2_c)))

where _c stands for those coordinates changed from . to ,

See you again,

Wolfgang

Re: geo coordinates add calculate

Anonymous — Wed, 26 Aug 2015 13:02:24 GMT

Hi Expert,

unfortunately the formula did not work.

I use the following now:

=sqrt
((111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))*
(111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))+
(111.3*(lat1_c-lat2_c))*(111.3*(lat1_c-lat2_c)))

and it brings to me distances which are correct (counterchecked in the Internet:-))

Best regards

Wolfgang