Discussion Board for collaboration on QlikView Scripting.
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 !!
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
Just create another data field to combine these two date fields.