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;