Qlik Community

QlikView Documents

Documents for QlikView related information.

Working Day Master Calendar


Working Day Master Calendar

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.

Valued Contributor

Nice one

Valued Contributor III

Thanks a lot for this contribution, very straightforward

Honored Contributor II

I change formula for the QUARTER (they are a value for quarter = 5 and is wrong)

ceil(month(Date)/3) as Qtr
Version history
Revision #:
1 of 1
Last update:
‎05-14-2015 06:13 AM
Updated by: