How to join table in this case?

nguyenviethung — Sun, 23 Jul 2017 05:58:55 GMT

Hi all Qlikers,

Below is my data model and let me explain my situation:

I get Trade program outlet-list (Table 1), which includes list of the outlets of certain programs. DiscusKey means the combination of Distributor and Customer.

Distributor sales-out (Table 2) is somehow like Sales order report by outlet (Customer). Distributor ID in this table links to the distributor structure (Table 3) to generate data by Area/Region/State....

The Table 1 includes 100 customers, for example, but not all of those purchased any product in one month, for example, let's say 90 of those 100 are in Table 2.

Then if i summarize sales by Trade program by Area/Region..., it only contains 90 customers appearing in table 2. This is fair.

The problem is: How to join table 1 and table 2 to answer questions like:

How many outlets joined a certain trade program by Area/Region?
How many of them purchased?

The outlets which did not purchased (Total Sales = 0) does not belong to any Area/Region/Distributor .. with this way of linking Distributor structure. (I must link this way, Distributor Structure should not be linked directly to Table 1)

I attached the QS app so that you guys can help me in the script. I also read this article but can not solve:

Left ‒ Qlik Sense

Thank you and sorry if my English is not good. Anyone needs further explain please comment.

topic How to join table in this case? in QlikView

How to join table in this case?