# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Creator

## First Quarter (Q1) begins with April

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;

or

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?

1 Solution

Accepted Solutions
Partner - Creator

Hi,

this should work

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

3 Replies
Partner - Creator

Hi,

this should work

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

Master II

Hi Paul:

try like this:

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

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

hope it helps!

Master II

try this way,

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

Community Browser