The trick is described in detail here: Trick #4 - Calendar Object Start Day
Now I have to warn you, this isn't a typical "use the aggr function" trick. This trick is more of a hack of QlikView. Please read all of the details (and warnings) described in the trick before you attempt to implement it.
In the coming days I'll be posting tricks for such things as:
- Dynamic support of multiple timezones
- Dynamic support of multiple languages.
- Meaningful average value displays
- User-friendly date/time selection
- and other surprises!
Stay tuned!
PS, I've also just added a bunch of helpful Hints. Check them out!