If I may ask, what are you trying to achieve with your various MC_* tables? I can't see the value in them and I think they may just be confusing the issue. Have you seen this article? It breaks the process of creating a canonical date down fairly simply using a data model very similar to the one you are working with.
I should also point out that you've posted in the new to Qlik Sense board when you appear to be using QlikView, not that it really matters with this type of query.