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