topic Re: calender in QlikView

calender

Thu, 11 Dec 2014 03:52:56 GMT

how to create calender for including next year....

My code is :

LET vTodaysDate = num(Today());

LET vStartDate = num(AddMonths(YearStart($(vTodaysDate)), -4 * 12));

LET vEndDate = num(YearEnd($(vTodaysDate)));

LET NumberOfDays = num(YearEnd($(vTodaysDate))) - $(vStartDate) + 1;

Date:

LOAD Max(Date) AS Date

FROM

$(STAGE1_TRANSACTION_DATE_QVD_PATH)Date_DAILYSALES.qvd

(qvd);

LET vDate=Floor(Num(Peek('Date',0,Date)));

Drop Table Date;

please reply soon...

nagaiank — Thu, 11 Dec 2014 04:02:11 GMT

You may use the calendar end date defined by

LET vEndDate = num(AddMonths(YearEnd($(vTodaysDate)), 12));

senpradip007 — Thu, 11 Dec 2014 04:08:48 GMT

You can use like

Date:

LOAD Min(Date) AS MinDate,

FROM

$(STAGE1_TRANSACTION_DATE_QVD_PATH)Date_DAILYSALES.qvd

(qvd);

LET vMaxDate=AddMonth(Today(), 12);

LET vMinDate=Peek('MinDate',0,Date);

Drop Table Date;