Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Just create another data field to combine these two date fields.