Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;