#18 🗺️ What If analysis and distance calculation in Qlik Sense
🗺️ Calculate distance on the fly and What If Analysis Qlik
Imagine you want to set up a shop, why not be the closest possible of the most of your client ?
In this example you can move 2 shops and change distance limit to analyse population.
Qlik gives you more super powers than just building great dashboard, you solve real life problem too !
In this sheet I mainly use variables, valuelist() and distance formula 🧙♂️
❓How To❓
To get the number of point for each shop :
Sum(aggr(if(
acos(sin(pi()*lat1/180)*sin(pi()*$(vNewLat1)/180)+cos(pi()*lat1/180)*cos(pi()*$(vNewLat1)/180)*cos(pi() * (long1-$(vNewLong1))/180))*180/pi()*60*1.1515*1.609344
<$(vMax),1,0)
,id))
Would be great with the power of Write Back extension like Forms ? Possible Mária Šándorová ?
Did you notice this nice Pie Chart ? 😉
Read more
