Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Roll date to month and Quater level in qlikview

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.

2 Replies
er_mohit
Master II
Master II

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

];

Not applicable
Author

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.