Discussion Board for collaboration on QlikView Scripting.
How can I get my calendar to display 24 rolling months from the last date in my table of dates? Here's the code for the start end endpoints:
min(OrderDate) as MinDate,
max(OrderDate) as MaxDate
LET Start = floor(YearStart(peek('MinDate')));
LET End = floor(???);
Drop Table tmp;
Grateful for any help!
Go to Solution.
let End = addmonths(peek('MaxDate,0,tmp),24);
LET Start = floor(YearStart(peek('MinDate',-1,tmp)));
LET End = floor(YearStart(peek('MaxDate,0,tmp)));
That set the End date of the calendar to january first of the year of the last OrderDate. I need the last date to be 24 months after the last OrderDate.
That works! Thanks a lot!