Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

FirstMonthOfYear Use in QlikSense

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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: FirstMonthOfYear Use in QlikSense

I found the following link which is really helpful for me.

how to calculate financial year start date from... | Qlik Community

1 Reply
Not applicable

Re: FirstMonthOfYear Use in QlikSense

I found the following link which is really helpful for me.

how to calculate financial year start date from... | Qlik Community