How to Roll date to month and Quater level in qlikview

[#1]

Hi All,

We have are facing issues in regards to roll date at month and quater level in qlikview.

Our datasource is Excel sheet and the date format is as below (D/MM/YYYY):

2/18/2010

3/31/2010

3/19/2010

5/7/2010

6/18/2010

4/20/2010

5/3/2010

12/31/2010

5/15/2010

8/15/2010

6/21/2010

6/25/2010

7/27/2010

12/3/2010

6/29/2010

6/29/2010

7/16/2010

8/7/2010

7/12/2010

We wish to roll up the dates to month and quarter level in qlikview.

Your help is highly appreciated.

[er_mohit]

See the attahed file

ok

i edited in this just copy and paste in your Script and reload it

hope it helps

Temp_Date:

LOAD *,'Q' & Ceil(Month(DATE)/3) AS CalendarQuarter,Month(DATE) AS CalendarMonthName;

load Date(Date#(Date,'MM/DD/YYYY'),'DD/MM/YYYY') as DATE,

* INLINE [

    Date

    2/18/2010

    3/31/2010

    3/19/2010

    5/7/2010

    6/18/2010

    4/20/2010

    5/3/2010

    12/31/2010

    5/15/2010

    8/15/2010

    6/21/2010

    6/25/2010

    7/27/2010

    12/3/2010

    6/29/2010

    6/29/2010

    7/16/2010

    8/7/2010

    7/12/2010

];

[#3]

Hi Mohit,

We are using personal edition of QV hence cannot access .qvw file posted by you.

We would appreciate if you can paste the expression here or send us an txt file.