Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hkg_qlik
Contributor II

Calendar (Multiple dates in FACT)

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

Tags (1)
2 Replies
Employee
Employee

Re: Calendar (Multiple dates in FACT)

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

Not applicable

Re: Calendar (Multiple dates in FACT)

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

Community Browser