Discussion Board for collaboration related to QlikView App Development.
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):
We wish to roll up the dates to month and quarter level in qlikview.
Your help is highly appreciated.
See the attahed file
i edited in this just copy and paste in your Script and reload it
hope it helps
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 [
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.