Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajsjoshua
Contributor III

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;

Tags (1)
1 Solution

Accepted Solutions
undergrinder
Valued Contributor II

Re: Storing qvd in next month name

3 Replies
undergrinder
Valued Contributor II

Re: Storing qvd in next month name

ujjwalraja
New Contributor III

Re: Storing qvd in next month name

Modify it with

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

balabhaskarqlik
Honored Contributor

Re: Storing qvd in next month name

May be:

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

Community Browser