Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have an excel file with longitudes and latitudes, i would like to know if it's possible to get a real representation of the distances between the locations taking into account streets as in Google map. So far i found a way to find the distances but i am wondering if there's a possibility to get distances to be realistic taking into account streets and not just a simple A to B distance.
I think the only solution to calculate the real distance between two points is by using Qlik GeoAnalytics.
Routes and travel areas in IdevioMaps
I think the only solution to calculate the real distance between two points is by using Qlik GeoAnalytics.
Routes and travel areas in IdevioMaps
if you have two lat longs this will convert to 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;