Date in 4 Quarter

Fri, 01 Jun 2012 05:46:10 GMT

Dear Team,

I am able to split my data in Month and Year on using...

Load Date,

Month (Date) as Month,

Year (Date) as Year,

from

FROM

(biff, embedded labels, table is Fact$);

But plz tell me the command by which i can devide the Date or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .

Regards,

Rahul

Re: Date in 4 Quarter

Sokkorn — Fri, 01 Jun 2012 06:37:44 GMT

Hi Rahul,

Try this:

Load Date, 
     Month (Date) as Month,
     Year (Date) as Year,
     'Q' & CEIL(MONTH([Date])/3)     as Quarter
FROM
(biff, embedded labels, table is Fact$);

Hope this help.

Regards,

Sokkorn

topic Date in 4 Quarter in QlikView

Date in 4 Quarter

Re: Date in 4 Quarter