Fiscal Year Calendar Generation

Arvind_07 — Sat, 16 Nov 2024 00:27:57 GMT

I'm new to Qlik sense and I'm trying to create a fiscal calendar in Qlik sense using my calendar table. Idea is calculate MTD/YTD sales based on the Week start/end Month start/end based on my calendar. Because Qlik's calendar week numbers are different than my calendar.

PS- When I say MTD it should be based on Week numbers instead of Date field because I intend to show the summary by week and that is why I'm trying to create a master calendar with week numbers which is same as my calendar

If anyone who could assist me on creating the calendar in Qlik sense which shows the Week number/Month start end dates same as my calendar that would be really helpful. Thank you all in advance.

I have attached my Calendar sheet below which contains all information.

Re: Fiscal Year Calendar Generation

Or — Wed, 10 Mar 2021 14:42:28 GMT

Have a look at this extensive solution for fiscal year / custom calendar periods. Hopefully it'll get the job done for what you need, or you can adapt it to match your needs.

https://community.qlik.com/t5/Qlik-Sense-Documents/Master-Calendar-Script-with-Optional-Fiscal-Year/ta-p/1692173

topic Fiscal Year Calendar Generation in App Development

Fiscal Year Calendar Generation

Re: Fiscal Year Calendar Generation