topic Re: Load Month End in QlikView

Load Month End

Anonymous — Mon, 30 Sep 2013 15:01:24 GMT

Hello,

I am trying to load data from previous month end. I am trying to use a variable so that it can run automatically without changing the date.

This does not seem lo work.

LET vPreviousMonth = addmonths(max(Today()),-1);

SELECT $(vPreviousMonth);

LOAD ....

SQL SELECT *
FROM ...File
WHERE "posting date" <= $(PreviousMonth);

CELAMBARASAN — Mon, 30 Sep 2013 15:15:23 GMT

LET vPreviousMonth = Date(addmonths(max(Today()),-1), 'DD/MM/YYYY';

LOAD ....

SQL SELECT *
FROM ...File
WHERE "posting date" <= '$(PreviousMonth)';

Anonymous — Mon, 30 Sep 2013 15:21:59 GMT

I am still getting a syntax error when trying to load.

Anonymous — Mon, 30 Sep 2013 15:26:19 GMT

Hi,

If you need monthend then use:

LET vPreviousMonth = monthend(addmonths(Today(),-1));

MK_QSL — Mon, 30 Sep 2013 15:45:05 GMT

Try this...

LET vPreviousMonth = Monthend(Today(),-1)

Your load statement

SQL Select * from ......

WHERE DATE(YourDate),'DD/MM/YYYY') <= Date('$(vPreviousMonth)', 'DD/MM/YYYY');

Anonymous — Mon, 30 Sep 2013 15:53:41 GMT

I'd use this:

date(monthstart(Today())-1)

Clever_Anjos — Mon, 30 Sep 2013 16:32:05 GMT

LET vPreviousMonth = date(monthend(addmonths(Today(),-1)),'YYYY-MM-DD');

SELECT $(vPreviousMonth);

LOAD ....

SQL SELECT *
FROM ...File
WHERE "posting date" <= '$(PreviousMonth)';