Fiscal Quarter from Mar to Feb

[DerickMulder]

Hi Guys

Hope someone can help me with this I am kinda stuck,

My fiscal year starts on the 1st of March and ends on the 28/29th of Feb every year, I have a yearly quarter in my QlikView that is divided into the 12 months of any given year, but I want to use my actualy fiscal quarter,

e.g

Q1 = 1Mar to May

Q2 = 1Jun to Aug

Q3 = 1Sept to Nov

Q4 = 1Dec to Feb

how would I achieve this? 

[Victor_Alumanah · Accepted solution]

Do you have a master calendar in your script? if so you can add the lines below and change "TempDate" to your date value.

Num(Month(AddMonths(TempDate,(10))),00) as FiscalMonth

'Q' & CEIL(MONTH(addmonths(addyears(TempDate,1),-2)) / 3) AS FiscalQuarter

[DerickMulder]

Thanks, Victor!

Luckily I already had a master calendar. it works 100%

[DerickMulder]

Sorry Victor just one more question, The quarters show as Q4, Q1, Q2, Q3 I cannot seem to sort it to look like Q1, Q2, Q3, Q4? Any Suggestions?