Which join to use - left or inner? How to measure distance between gps co-ordinates?

[#1]

In the spreadsheet attached, there are two tabs, [LocationGPS & Attributes] and [str - itm - wk sales data].  The first tab holds two types of store statuses, i.e. EXISTING STORES and @home stores, GPS co-ordinates and Province. The second tab holds sales data against the Store & item, but only for the EXISTING STORES.

First question, how do we join the two tabs, so that we can view both the EXISTING STORES & @home stores on a map? And then measure the distance between locations, so that we can answer the question, which EXISTING STORES are <10km from an @store?

Second question, for those EXISTING STORES <10km from an @store, what is the sales for the items in that store?

[Gysbert_Wassenaar]

Perhaps this discussion helps: How do I use latitude and longitude values to find near by records

Or this one: WGS84 Compliant Great Circle Distance Calculation

Or one of the search results of this search: https://community.qlik.com/search.jspa?q=latitude+distance

[swuehl]

Maybe have a look at

How do I use latitude and longitude values to find near by records

[#4]

This is in Qlik sense and not Qlikview. Or is it the same answer?

[Gysbert_Wassenaar]

Yes, the script and expression syntax is the same.

[#6]

is there not a formula that someone has to do this?

[Gysbert_Wassenaar]

There is no formula implemented in Qlikview or Qlik Sense as a native function.