Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

6 Replies
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


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

Not applicable
Author

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.


talk is cheap, supply exceeds demand