topic Re: Can QV calculate Distance Between 2 Points? in QlikView

Can QV calculate Distance Between 2 Points?

l_palacios — Mon, 26 Jan 2026 18:19:17 GMT

Can qlikview calculate distance between 2 latitude, longitude points and GPS points?

Re: Can QV calculate Distance Between 2 Points?

MK_QSL — Wed, 28 Mar 2018 17:41:39 GMT

Show distance between two points

Calculating distance using Latitude and Longitude

distance between two coordinates

Re: Can QV calculate Distance Between 2 Points?

richard_pearce6 — Fri, 13 Nov 2020 09:36:32 GMT

This will do it for km:

DataShort:
Load *

     ,6371 * (2 *
           Atan2( 
                   sqrt((sin(((lat2-lat1) * Pi() /180) /2) * sin(((lat2-lat1) * Pi() /180) /2) +sin(((lon2-lon1) * Pi() /180) /2) * sin(((lon2-lon1) * Pi() /180) /2) * cos(((lat1) * Pi() /180) ) * cos(((lat2) * Pi() /180) )))
               ,  sqrt(1-(sin(((lat2-lat1) * Pi() /180) /2) * sin(((lat2-lat1) * Pi() /180) /2) +sin(((lon2-lon1) * Pi() /180) /2) * sin(((lon2-lon1) * Pi() /180) /2) * cos(((lat1) * Pi() /180) ) * cos(((lat2) * Pi() /180) )))

            ))  AS Distance
Resident Data;