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.
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
