Shared Time Calendar between 2 Sales related data sets - causing a loop

[Anonymous]

Hello

I need to use a shared Time Calendar that can join two separate tables on the DateID, without causing a loop.
I have the following Scenario:

I need the OrderCalandar to be join to both sales related tables (That in turn connect to the EmployeesTable)
This is neccesary so i can placea  date filter on the page, and if a User choses all sales in May, they will be able to see all Sales and All RMA's that have happened in May

Like this:

You can filter on May - and theoretically - data for both datasets will come through

Any one able to help me on this please

[justinvchiang]

Best option is to create a link table since you have two separate fact tables with shared dimensions:

Check this out:

Qlik Tips: Rules for creating a Key/Link Table in QlikView