Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

geo coordinates add calculate

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

11 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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