Calendar (Multiple dates in FACT)

[hkg_qlik]

Hi all,

I have two dates in a a MRP Message (FACT TABLE) table.

1. REQUEST DATE

2. START DATE

My analysis depends on both dates and that's why need a common calendar to drive both dates.

Please advise !!

Regards,

H

[hic]

Take a look at the tutorial "Using Common Date Dimensions and Shared Calendars" at http://robwunderlich.com/tutorials/.

Also, look at http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles

HIC

[#3]

Just create another data field to combine these two date fields.