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

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

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

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

justinvchiang — Wed, 13 Dec 2017 23:15:09 GMT

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

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

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

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