Dates in Fact table

[Gang]

Hi ,

I have 3 fact tables out of it 2 tables has dates in it. Am trying to create a canonical dates for it. Unfortunately am landing up in circular reference.  Please find the sample below

[Or]

Have a look at Henric's post here, specifically the second part:

https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578

[Gang]

That's how I created this canonical date but still no luck. 

[Or · Accepted solution]

Your issue is that your three fact tables are connected to each other, which is creating a circular reference (though you knew that already) - you need to re-work your schema so this isn't the case, most commonly by using a single key for all three.

If you have QlikView or can download the Personal Edition of it, Rob's post here has a QVW demonstrating this: https://community.qlik.com/t5/QlikView-Documents/Linking-to-two-or-more-dates/ta-p/1495322

I don't think you can set up what you're trying to do while also maintaining three separate tables linked to each other with separate keys, so you'll have to address that basic issue somehow.