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,