Documents for QlikView related information.
There is quite a lot of information on Master Calendars elsewhere in the posts especially determining minimum and maximum dates from the main data to set the master calendar range.
Attached is a variation of the theme which builds a master calendar but only for the main working days (i.e. excludes Saturdays and Sundays)
A further modification would be to incorporate a bank holiday file for exclusion. This could utilize the where not exists functionality.
Thanks a lot for this contribution, very straightforward
I change formula for the QUARTER (they are a value for quarter = 5 and is wrong)