Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Fiscal Calendar Table load script

New Contributor III

Fiscal Calendar Table load script

The first part of this file is a Qlik load script section that creates a fiscal calendar table (FiscalCal) based on an existing date field

( has already been loaded - typically in a fact table).  The calendar table includes a link key field named ^FCalLink, and the fact table needs a date field with the same name.  The section is intended to be saved to an include file so that is can be easily used by multiple apps, as a standard fiscal calendar table.

The second part is a sample load script section that uses the first part.

Tags (1)
Contributor II
This is fantastic. Had to make a couple of minor tweaks to get it up and running but works as expected. Thanks a lot for taking the time to put this together. Saved a lot of my time. Cheers , Sid
Version history
Revision #:
1 of 1
Last update:
‎2018-04-03 10:47 PM
Updated by: