topic Re: Not getting the correct quarter number in QlikView

Not getting the correct quarter number

Anonymous — Thu, 20 Oct 2011 09:24:44 GMT

Hi Guys,

I have the field quarter that doesn't show the correct quarter numbers:

Based on the script below,

'Q' & Ceil(Month(Date(Date#(OrderDate, 'YYYYMMDD'),'DD-MM-YYYY') /3)) as Quarter,

OrderDate is a string therefore I used the Date# to translate it to a date.

I get these results

What am I doing wrong?

Cheers!

iSam

Miguel_Angel_Baeyens — Thu, 20 Oct 2011 09:33:53 GMT

Hi Isam,

I cannot see the attached image, but you have a parenthesis moved, the correct syntax is to divide the month into 3:

'Q' & Ceil(Month(Date(Date#(OrderDate, 'YYYYMMDD'),'DD-MM-YYYY')) /3) AS Quarter,

Hope that helps.

BI Consultant

jonathandienst — Thu, 20 Oct 2011 09:37:24 GMT

You have a misplace ) sign.

'Q' & Ceil(Month(Date#(OrderDate, 'YYYYMMDD')) / 3)

You could also use

QuarterName(Date#(OrderDate, 'YYYYMMDD'))

Hope that helps

Jonathan