topic Re: How to calculate quarter based on datetime field ? in QlikView

How to calculate quarter based on datetime field ?

ananyaghosh — Wed, 13 May 2015 12:17:35 GMT

Hi,

I need to know how quarters in a year will be calculated based on current date time and also based on date field from my database.

If I have a field of type date and need to calculate Quarters (Suppose Q1, Q2, Q3 and Q4), then how to do that thing?

buzzy996 — Wed, 13 May 2015 12:19:56 GMT

try tis in ur script Date/calendar table.

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

ToniKautto — Wed, 13 May 2015 12:22:02 GMT

=Num(Ceil( Month(MyDate)/ 3 ), 'Q0')

manojkulkarni — Wed, 13 May 2015 12:25:46 GMT

use some thing like below as Mapping table :

QuartersMap:

MAPPING LOAD

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter

AUTOGENERATE (12);

rajkumarb — Wed, 13 May 2015 12:58:26 GMT

HI Try This

QuartersMap:

MAPPING LOAD

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter

AUTOGENERATE (12);

MasterCalendar:

Load

TempDate AS DATE,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

Day(TempDate) As Day,

date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

Year(TempDate) & ' ' & ApplyMap('QuartersMap', month(TempDate), Null()) as CalendarYearQuarter,

RIGHT(Year(TempDate) & ' ' & ApplyMap('QuartersMap', month(TempDate), Null()), 2) AS CalendarQuarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;