Timesheet data model (multiple many to many relations)

[BartVA]

I have the following basic data.

Timesheet records:

Employee	Duration (min)	Product tags ID	Customer Tags ID
AB	60
AB	90	1
AB	10	2	1
JR	50		2
JR	15	3
JR	30	4	3

Product tags:

Product tags ID	Product ID
1	101
1	102
1	103
2	101
3	103
3	105
4	200
4	201
4	202
4	203

Customer tags:

Customer Tags ID	Customer ID
1	1000
2	1000
2	1001
2	1002
3	1001
3	1003

I want to be able to report eg. on customer 1000 or on product 101 the sum of duration. If I just do a join (two joins actually), then the duration will multiply. Same problem if I load the tables separately and let Qlik do the relations (I think). How do I model this correctly? Any insights would be greatly appreciated!

[Vegar · Accepted solution]

If you don't join then you will get the figures correct.

Aim for a data model like my image below.

Then you can get data like in my image below

Selecting Customer 1000 will give 10+50= 60min. 

Selecting product 101 will give 10+90=100 min

----

[Timesheet records]:
LOAD Employee,
[Duration (min)],
[Product tags ID],
[Customer Tags ID]
FROM
[timesheet_concept.xlsx]
(ooxml, embedded labels, table is Sheet1);

[Product tags]:
LOAD
[Product tags ID1] as [Product tags ID],
[Product ID]

FROM
[timesheet_concept.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE Exists([Product tags ID], [Product tags ID1])
;
[Customer tags]:
LOAD
[Customer Tags ID1] as [Customer Tags ID],
[Customer ID]
FROM
[timesheet_concept.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE Exists([Customer Tags ID], [Customer Tags ID1]);

[BartVA]

Great, thanks!