Many to many relationship data model example

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

I have a data model requirement where I require to build "many to many" relationship between two tables. just wondering if anyone can share some example on how to construct this:

The current two table are as below where I have a key Plink to link them together and I have supplier name in the first table with measure in the second table. I want to introduce a third table where I will store four dimension of data: Supplier Name, Month, Year and Number of products. the aim is that in my front end I will be able to tell for each period, the sales for each product and with the number of product sold in that month, please be ware I won't be able to insert the information into the Sales table as the below is just a simplification of my current data model.

current report that can be built from the current model and I want to build additional one field to show the number of products sold in the month.

topic Many to many relationship data model example in QlikView

Many to many relationship data model example