Custom Quarter in Qlik Sense

[Kaushik2020]

Dear All,

Currently DateKey is created based on CreatedDate column and i am connecting to a master Calendar to call required Quarter labels like Q1, Q2... 

we have below requirement to show in Qlik Sense where we need to show Quarters based on the month. Refer Required Quarter column. 

Month	Generic Quarter	Required Quarter
Jan	Q1-2025	Q4-2024
Feb	Q1-2025	Q4-2024
Mar	Q1-2025	Q4-2024
Apr	Q2-2025	Q1-2025
May	Q2-2025	Q1-2025
Jun	Q2-2025	Q1-2025
Jul	Q3-2025	Q2-2025
Aug	Q3-2025	Q2-2025
Sep	Q3-2025	Q2-2025
Oct	Q4-2025	Q3-2025
Nov	Q4-2025	Q3-2025
Dec	Q4-2025	Q3-2025

Please suggest.

Thanks in advance.

[henrikalmen · Accepted solution]

This is a guide for custom fiscal year calendars in qlik: https://community.qlik.com/t5/Qlik-Sense-Documents/Master-Calendar-Script-with-Optional-Fiscal-Year/... 

You can find many more examples by searching the community.

[Kaushik2020]

Thanks a lot for the swift response. Much appreciated. this is what I was looking at.