Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Storing qvd in next month name

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;

1 Solution

Accepted Solutions
3 Replies
undergrinder
Specialist II
Specialist II

ujjwalraja
Contributor III
Contributor III

Modify it with

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

balabhaskarqlik

May be:

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