1 Reply Latest reply: Jul 28, 2017 8:21 AM by Kaleel Ahamed RSS

    FirstMonthOfYear Use in QlikSense

    Kaleel Ahamed

      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.