Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calender

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...

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

You may use the calendar end date defined by

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

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

You may use the calendar end date defined by

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

View solution in original post

senpradip007
Specialist III
Specialist III

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;