Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

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
MVP
MVP

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

Not applicable

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

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

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

Yes, the script and expression syntax is the same.


talk is cheap, supply exceeds demand
Not applicable

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

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

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

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


talk is cheap, supply exceeds demand
Community Browser