topic Re: Define Quarter? in QlikView

Define Quarter?

Tue, 29 Sep 2015 11:17:53 GMT

I have the Date field by using this field how can I Define the Quarter , yearQrtr ?

Thanks

Madhu

sunny_talwar — Tue, 29 Sep 2015 11:19:21 GMT

May be this:

'Q' & Ceil(Month(DateField)/3) as Quarter,

Year(Date) & 'Q' & Ceil(Month(DateField)/3) as YearQuarter

or you can also try this for YearQuarter:

Dual(Year(Date) & 'Q' & Ceil(Month(DateField)/3), Num#(Year(Date) & Ceil(Month(DateField)/3), '##')) as YearQuarter

sunny_talwar — Tue, 29 Sep 2015 11:21:25 GMT

SreeniJD — Tue, 29 Sep 2015 11:21:29 GMT

You have to explicitly convert the date into quarters..

see below expression..

'Q' & ceil(Num(month([$(_datefield)]))/3) as [$(_prefix)Qtr]

Tue, 29 Sep 2015 11:23:58 GMT

Q means naming convention right.

What is the use of Ceil and why u r using the Ceil beforedate function.

Tue, 29 Sep 2015 11:24:42 GMT

Try

'Q' & ceil(month(Date_field)/3) as yearQrtr

Pallav

Tue, 29 Sep 2015 11:26:40 GMT

josna g,

In your script add the folowing line for your date field:

Year(<datefield>) & Ceil(Month(<datefield>)/3) As YearQuarter

to show YearQuarter as 20151, 20152, etc..

Or with some formatting:

Year(<datefield>) & NUM(Ceil(Month(<datefield>)/3), '00') As YearQuarter

to show YearQuarter as 201501, 201502, etc..

Marc

sunny_talwar — Tue, 29 Sep 2015 11:54:50 GMT

Ceil is just used for rounding up the Month/3. So if you have January (which is also month number 1), you will have Ceil(1/3) = Ceil(0.33333) = 1

Feb -> Ceil(2/3) = Ceil(0.66666) = 1 and so on

HTH

Best,

Sunny