topic First Quarter (Q1) begins with April in QlikView

First Quarter (Q1) begins with April

Anonymous — Tue, 21 Apr 2015 13:13:43 GMT

Dear Community,

i am generating quarters on my dates and tried these solutions:

'Q'&If(Month(QuarterStart(DATE))='1',4,Div(Month(QuarterStart(DATE)),3)) as DATE_QUARTER;

if(len(DATE)>0, 'Q' & ceil(month(DATE)/3),ceil(month(DATE)/3)) as DATE_QUARTER;

Unfortunately the first quarter (Q1) begins all the time with April.

It should begin with January! How can i achieve this?

Please help

Re: First Quarter (Q1) begins with April

sebastianlettner — Tue, 21 Apr 2015 13:18:24 GMT

Hi,

this should work

'Q' & Ceil(Month(Date)/3) as Quarter

Re: First Quarter (Q1) begins with April

Frank_Hartmann — Tue, 21 Apr 2015 13:23:38 GMT

Hi Paul:

try like this:

TempCalendar:  
LOAD 
$(vDateMin) + RowNo() - 1 AS DateNumber,  
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1  
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

MasterCalendar:  
LOAD 
'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter
RESIDENT TempCalendar ORDER BY TempDate ASC; 
DROP TABLE TempCalendar;

hope it helps!

Re: First Quarter (Q1) begins with April

buzzy996 — Tue, 21 Apr 2015 13:27:22 GMT

try this way,

Ceil(Month([Order Date])/3) As Quarterly,