Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Raju_6952
Creator II
Creator II

quarter calculations with custom Fiscal Year

Hi ,

I want to calculate the quarter filed if fiscal year starts from sep-2023 and ends at AUG -2024, In this scenario the months will starts from sep -2023.now I have to calculate the quarter filed which starts from sep 2023.

september Q1
cotober
november
december Q2
january
febrauary
march Q3
april
may 
june Q4
July
August

 any Suggestions would be highly appreciated.

 

Regards,

Raju

 

 

Labels (2)
1 Reply
TcnCunha_M
Creator III
Creator III

Hi

Please see this:

https://community.qlik.com/t5/Design/Fiscal-Year/ba-p/1472103

 

Or there is a variable you may have to use: 

Change SET FirstMonthOfYear=1; to SET FirstMonthOfYear=9;

 

 

As you think, so shall you become.