topic Master Calender in QlikView

Master Calender

upaliwije — Wed, 12 Feb 2014 16:01:09 GMT

calender:

LOAD

Date(T_DATE) AS T_DATE,

Year(T_DATE) AS T_YEAR,

Month(T_DATE) As T_MONTH;

Load Date(T_MinDate + IterNo() -1 ) AS T_DATE While (T_MinDate + IterNo() - 1) <= Num(T_MaxDate);

Load

Min(T_DATE) AS T_MinDate,

Max(T_DATE) AS T_MaxDate

RESIDENT sales;

I have created the above master calender. I want to add YEAR-MON field to the above calender.

Please help me to add the code for it in the above script

giakoum — Wed, 12 Feb 2014 16:06:14 GMT

Year(T_DATE) & Month(T_DATE) As T_YEAR_MONTH

Wed, 12 Feb 2014 16:06:16 GMT

Try :

dual(year(T_DATE) & '-' & month(T_DATE),

year(T_DATE) & num(month(T_DATE), '00')) as T_YearMonth,