Hello All,
I am trying to build a master calendar date dimension to hold various informaiton for date like, month, day, year etc. in QlikSense, We have requirement for Fiscal year, fiscal quarter as well. I understand using the FirstMonthOfYear Variable, I could coule derive FiscalYear and FsicalQuarter easiöly. but I am unable to get the correction funtion to make it work.
I have read the following discussion regarding the fiscal year, but with recent FisrtMonthOfYear variable, the whole of this could be simpler, I think,
https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year#comment-18082
Also, I can see the following link, which explained the usage of FirstWeekDay.
Redefining the Week Start in Qlik Sense
Possibly like if there is some explanation post on how to use FisrstMonthOfYear for the FiscalYear Calculation, it would be helpful.
