Join tables and link table

[fdbs]

Hello,

I am having difficulties in pooling data from different tables.

Here is the data schema of our Qlik Sense application : 

 

We use a data link table "LinkDataTable".

Here is an example of data :

In my Qlik Sense application, I would like to be able to make a simple table showing for each SKU/Marketplace, the status and the total stock of this SKU.

An example of an expected result :

The problem is that when I add my "stock total" column it doesn't work, the table becomes empty. What is the right way to use data from two external tables (Stock and ProductMarketplaces) with a linking table ?

In my set analysis of column "stock total" I tried to ignore the dimensions but it doesn't work.

Could you please help me ? 

[fdbs]

Oops, little mistake on the last picture.

In the expected result, in the"stock total" column, it is not 15 but 20 (5 + 5 + 10) for the BBQ SKU

[Sammy_AK]

why do you need a link data table ? you should be able to join just stock and Product market place using the column SKU, this should give you the result you are looking for...