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