topic Re: Master calender in QlikView

Master calender

Wed, 10 Jul 2013 04:03:50 GMT

how to do master calender for one month

Example:For May 25 to june 25

Re: Master calender

Siva_Sankar — Wed, 10 Jul 2013 04:15:49 GMT

Hi, Try rob's qlikview components.(http://qlikviewcomponents.org). The entire script to generate your calendar would be: $(Include=..\qvc_runtime\qvc.qvs); CALL Qvc.CalendarFromField('OPEN_TIME'); CALL Qvc.CalendarFromField('ORIG_DATE_ENTERED'); Regards. Siva

Re: Master calender

Sokkorn — Wed, 10 Jul 2013 04:56:31 GMT

Hi,

Try below script

Let varMinDate = Num(Date(Date#('25-May-2013','dd-MMM-yyyy')));
Let varMaxDate = Num(Date(Date#('25-Jun-2013','dd-MMM-yyyy')));
TempCalendar:
LOAD
   $(varMinDate) + Iterno()-1 As Num,
   Date($(varMinDate) + IterNo() - 1) AS TempDate
   AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
MasterCalendar:
Load
    
    TempDate,
    WEEK(TempDate)                AS [Weeks],
    MONTH(TempDate)                AS [Months],
    CEIL(MONTH(TempDate)/3)        AS [Quarters],
    YEAR(TempDate)                AS [Years]
Resident TempCalendar;
DROP Table TempCalendar;

Regards,

Sokkorn