Data Modeling Multiple date issue

[#1]

How to deal with multiple dates in data model.

Each table have one date  I need a universal date it should work with all  tables

please find attached excel and Qvw please  suggest

[m_woolf]

Tutorial - Using Common Date Dimensions and Shared Calendars

[Oleg_Troyansky]

There are many ways of dealing with this problem. My favorite solution is to build a concatenated fact table with all your facts as concatenated slices, and rename all your dates into one field name Date. This way, you can use one Master Calendar for all dates and differentiate you dates using the new field that we usually call "Fact Type".

You can learn these Data Modeling techniques at the Masters Summit for Qlik - coming to Boston this October. If you can't attend the Masters Summit, check out my book QlikView Your Business. I also describe these techniques there.

cheers,

Oleg Troyansky

[#4]

i cant understand where to use  that call calander

please help it's aurgent

[Anil_Babu_Samineni · Accepted solution]

I agree with Oleg.

Check here the solution in attachment. I've attached qvw and qvs.

[#6]

Awesome Anil Thanks.