topic Re: Change Qrt Start Date in QlikView

Change Qrt Start Date

Tue, 23 Apr 2013 19:33:17 GMT

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. 🙂

Re: Change Qrt Start Date

MayilVahanan — Tue, 23 Apr 2013 19:47:35 GMT

Try like this

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

Hope it helps

Re: Change Qrt Start Date

Oleg_Troyansky — Tue, 23 Apr 2013 20:27:55 GMT

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

Re: Change Qrt Start Date

Tue, 23 Apr 2013 20:33:02 GMT

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

Re: Change Qrt Start Date

CELAMBARASAN — Tue, 23 Apr 2013 23:24:24 GMT

Hi,

Try this

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

Hope it helps

Celambarasan

Re: Change Qrt Start Date

Wed, 24 Apr 2013 05:29:11 GMT

try this

load

yearname(date,0,8) as date,

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

from test table

hope this helps you

Re: Change Qrt Start Date

er_mohit — Wed, 24 Apr 2013 06:00:54 GMT

try this

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