Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pinky1234
Contributor III
Contributor III

Need help on Fiscal Quarter Calendar

Hi,

I have a date field and using that date field I would like to generate the Fiscal Quarter calendar? My Fiscal starts from Oct-1st ends in Sep30. So  I would like to  generate the calendar and show Quarters like below. I tried different ways it didn't work so I am requesting please share me the code that works for my scenario .  Thank you in advance!

Oct-Dec 2020-Q1 2021

Jan- Mar 2021- Q2 2021

Apr-June 2021- Q3 2021

July - Sep 2021-Q4 2021

Oct-Dec 2021-Q1 2022

Jan- Mar 2022 - Q2 2022

Apr-June 2022- Q3 2022

July - Sep 2022-Q4 2022--Etc

 

 

 

1 Reply
anat
Specialist II
Specialist II