How to create calendar in QV?

Mon, 26 May 2014 11:03:18 GMT

Please help me with script to creat calendar (Quater, Half year,Month,Year)

Re: How to create calendar in QV?

Anonymous — Mon, 26 May 2014 11:05:56 GMT

SET STARTDATE = ’01-01-2006′; //fill in your start date
LET ENDDATE = date(today());
[TEMP_DATE]:
LOAD
date( date#(‘$(STARTDATE)’,'DD-MM-YYYY’)-1 + recno() ,’DD-MM-YYYY’) as DATE
AUTOGENERATE (date#(‘$(ENDDATE)’) – date#(‘$(STARTDATE)’))+1;
[DATETABLE]:
LOAD
DATE,
Year(DATE) as YEAR,
Month(DATE) as MONTH,
Week(DATE) as WEEK,
WeekDay(DATE) as WEEKDAY,
Day(DATE) as DAY,
Year(DATE) & right(’00′ & week(DATE),2) as YYYYWW,
Year(DATE) & right(’00′ & num(Month(DATE)),2) as YYYYMM,
Year(DATE) & ceil(num(Month(DATE))/3) as YYYYK,
‘Quarter’ & ceil(num(Month(DATE))/3) as QUARTER
RESIDENT [TEMP_DATE];

DROP TABLE [TEMP_DATE];

topic Re: How to create calendar in QV? in QlikView

How to create calendar in QV?

Re: How to create calendar in QV?

Re: How to create calendar in QV?