Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Fiscal Calendar Table load script

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
john_obrien
Contributor III
Contributor III

Fiscal Calendar Table load script

Last Update:

Apr 3, 2018 10:47:54 PM

Updated By:

john_obrien

Created date:

Apr 3, 2018 10:47:54 PM

Attachments

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)
Comments
siddharth_kulka
Creator II
Creator 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
0 Likes
Version history
Last update:
‎2018-04-03 10:47 PM
Updated by: