Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Qrt Start Date

Hello,

i'm trying to change my default Quarter Month to begin on October instead of January.

i want Q1 = Oct, Nov, Dec but currently have Q1= Jan, Feb, Mar.

Thanks in advance. 🙂

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

try this

'Q'&If(Month(QuarterStart(TempDate,2))='1',4,Div(Month(QuarterStart(TempDate,2)),3)) as QuarterStartsOct,

View solution in original post

6 Replies
MayilVahanan

Hi

Try like this

'Q'&If(Month(QuarterStart(Date))='1',4,Div(Month(QuarterStart(Date)),3))

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

If Quarter is all you need, than this formula would probably cut it. In most cases, however, you'll need more than that:

- Fiscal period for October should be 01

- Fiscal YTD calculation needs to begin with October

- Fiscal QTD calculation needs to begin with the corresponding Quarter

For those purposes, I recommend calculating the difference in months between Jan 1 and Oct 1, and calculating a "Fiscal Date" for each one of the calendar Dates. Then, you can use regular Calendar functions, such as Quarter, InYearToDate, etc... for calculating the corresponding Fiscal attributes.

best,

Oleg Troyansky

Not applicable
Author

This is helpful but when i use the above formula Q1 =Apr, May, Jun Rather than Oct, Nov, Dec

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Try this

'Q'&Ceil(Num(Month(MonthStart(Max(InvoiceDate), -3))) / 3) As Quarter

Hope it helps

Celambarasan

Not applicable
Author

hi

try this

load

yearname(date,0,8) as date,

'Q' & ceil(Month(date)/3) as Quarter

from test table

hope this helps you

er_mohit
Master II
Master II

try this

'Q'&If(Month(QuarterStart(TempDate,2))='1',4,Div(Month(QuarterStart(TempDate,2)),3)) as QuarterStartsOct,