Storing qvd in next month name

[ajsjoshua]

Dear all,

I am using the below to store my qvd in current month name but i want to store the current month qvd in next month name.

LOAD LOAN_AC_NO,

NAME,

EMI_AMOUNT,

OVERDUE,

Month(LASTPROCESSDATE)&'_'&Year(LASTPROCESSDATE) as ReportingMonthYr

LASTPROCESSDATE;

[ODREPORT]:

SELECT "LOAN_AC_NO",

"NAME",

"EMI_AMOUNT",

"OVERDUE",

"LASTPROCESSDATE"

FROM "INT_USR"."ODREPORT";

MonthYear:

LOAD

ReportingMonthYr as MonthYear

Resident [ODREPORT];

LET vYearmonthstoreBounce = Peek('MonthYear');

STORE [ODREPORT] INTO [lib://TestQVDPATH /ODREPORT_Live_$(vYearmonthstoreBounce).QVD] (qvd);

Drop table [ODREPORT];

Drop table MonthYear;

[undergrinder · Accepted solution]

Hi Joshua,

Try the addmonths function

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/add...

G.

[ujjwalraja]

Modify it with

LET vYearmonthstoreBounce = Addmonths(Peek('MonthYear'),1);

[balabhaskarqlik]

May be:

LET vYearmonthstoreBounce = Peek(MonthYear,1,'MonthYear');