topic 24 rolling months from last date in QlikView

24 rolling months from last date

Thu, 24 Nov 2011 11:52:22 GMT

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:

tmp:

LOAD

min(OrderDate) as MinDate,

max(OrderDate) as MaxDate

RESIDENT Orders;

LET Start = floor(YearStart(peek('MinDate')));

LET End = floor(???);

Drop Table tmp;

Grateful for any help!

// John

Re: 24 rolling months from last date

rohit214 — Thu, 24 Nov 2011 11:59:28 GMT

hi john

try this

tmp:

LOAD

min(OrderDate) as MinDate,

max(OrderDate) as MaxDate

RESIDENT Orders;

LET Start = floor(YearStart(peek('MinDate',-1,tmp)));

LET End = floor(YearStart(peek('MaxDate,0,tmp)));

Drop Table tmp;

thanks

rohit

Re: 24 rolling months from last date

Thu, 24 Nov 2011 12:28:27 GMT

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.

24 rolling months from last date

lironbaram — Thu, 24 Nov 2011 12:54:53 GMT

let End = addmonths(peek('MaxDate,0,tmp),24);

24 rolling months from last date

Thu, 24 Nov 2011 13:09:22 GMT

That works! Thanks a lot!