topic Custom Fiscal Calendar in QlikView

Custom Fiscal Calendar

jblissard — Sat, 16 Nov 2024 18:38:30 GMT

I have a data set with actual dates tied to each line and wish to populate a Fiscal Year/Period/Week for the respective date. I have a separate file with the Fiscal calendar all the way back to 2015. Is there a simple way to join the two so that if it reads the arrival date on file one, it populates the respective Fiscal information from file two?

Re: Custom Fiscal Calendar

Brett_Bleess — Wed, 10 Jun 2020 14:20:26 GMT

Have a look at the following Design Blog posts, hopefully they may help you with this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Hopefully one of those will get you what you need.

Regards,
Brett