In the past we have created an example on how to overcome the challenge of building a date dimension table that also contains reporting periods of 4 weeks instead of only months.

In the attached (quite) simple example we show you how to easily create date dimensions that are derived from you master date dimension. Just follow the comments throughout the application and we hope this makes it easy to create multiple role playing date dimensions for your dimensional model.

 Kind regards,
The QlikConnect team.

PS: The next article will provide an example of Slowly Changing Dimensions in QlikView.