Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

Working Day Master Calendar

john_s_w_wood
Creator
Creator

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.

Attachments
Comments
mayankraoka
Specialist
Specialist

Nice one

0 Likes
beck_bakytbek
Master
Master

Thanks a lot for this contribution, very straightforward

0 Likes
ecolomer
Master II
Master 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:
‎2015-05-14 06:13 AM
Updated by: