topic Re: Last 3 months variable in QlikView

Last 3 months variable

Anonymous — Tue, 08 Oct 2013 18:16:39 GMT

Hi,

Any help with a variable that load last three months in current year variable.(including current date) to extract data.

Thanks

Gysbert_Wassenaar — Tue, 08 Oct 2013 18:34:23 GMT

Something like this if your date field is named Date and has numeric date values:

LET vLimit = addmonths(today(),-3);

Table1:

load * from ...sourcetable...

where Date >= $(vLimit);

felipe_dutra — Tue, 08 Oct 2013 19:11:43 GMT

Hi!

I would add the function RangeMax () to ensure that only work with the current year.

LET vLimit = Date(Rangemax(YearStart(Today()), addmonths(Today(),-3)));