topic Re: Join tables and link table in App Development

Join tables and link table

fdbs — Fri, 21 May 2021 09:40:03 GMT

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 ?

Re: Join tables and link table

fdbs — Fri, 21 May 2021 09:47:08 GMT

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

Re: Join tables and link table

Sammy_AK — Mon, 24 May 2021 11:26:18 GMT

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