topic How to Retrieve Quarter from the Date field in QlikView

How to Retrieve Quarter from the Date field

Fri, 01 May 2009 15:08:59 GMT

How to retrieve the Quarter and period from the Date field?Please give me an example?

How to Retrieve Quarter from the Date field

Fri, 01 May 2009 15:29:34 GMT

Try this:


'Q' & CEIL(MONTH(DATE(Transaction_Date)/3) AS Transaction_Quarter

How to Retrieve Quarter from the Date field

Fri, 01 May 2009 15:59:52 GMT

Dear Mark,

Could you please explain this expression. When do you divide by 3. Is there should be a closing braces?

How to Retrieve Quarter from the Date field

Fri, 01 May 2009 16:17:33 GMT

I use this expression in our reload script to generate a quarter (Q1/Q2/Q3/Q4) for the transaction date.
The expression takes divides the monthnumber by 3 and always rounds upwords CEIL() -> ceiling

For example
Monthnumber(5-10-2008)->10
10/3=3.33
Ceil(3.33)=4

How to Retrieve Quarter from the Date field

prieper — Fri, 01 May 2009 16:30:49 GMT

Hi,

QuarterName(YourDate) is also a nice function and delivers a date, which then might be used like other numeric data (sorting, filtering, >, etc)

HTH

How to Retrieve Quarter from the Date field

Thu, 12 May 2011 10:32:18 GMT

hi mjanssen,

Thanks a lot for your simple trick.I was worrying in sqldeveloper,there also i have resolved it in the same way.

Regards,

Sushma K

Re: How to Retrieve Quarter from the Date field

Anonymous — Fri, 29 Jun 2012 19:51:41 GMT

Mark Janssen escribió:
Try this:
'Q' & CEIL(MONTH(DATE(Transaction_Date)/3) AS Transaction_Quarter

'Q' & CEIL(MONTH(DATE(Transaction_Date)/3)) AS Transaction_Quarter ------ This Calculate all Q from your data like this Q1 Q2 Q3 Q4 Q5....

Re: How to Retrieve Quarter from the Date field

Anonymous — Fri, 29 Jun 2012 19:53:29 GMT

This Calculate de Q1 Q2 Q3 Q4...

'Q' & CEIL(MONTH(Transaction_Date)/3)

AS Transaction_Quarter