Monthly QVDs

[#1]

Hi,

Basically the company I work for handles tons of transactions every minute. To more effectively be able to handle the QVW I have a transformations stage that splits it into Monthly QVDS. So theres yearly and monthly QVDs.

By the beginning of each month I want to make invoice reports that take last months QVD not current. And from there I schedule nprinting jobs.

See below is what I want to do but it doesnt work because qlikview cant refer

These are my QVDs:

2016-03.qvd

2016-04.qvd

This is what I write in the script:

LET vLastMonth = Month(Today()-1);

[............\ExecutionReport_$(vLastMonth).qvd]

But qlikview cant refer to monthnames... 2016_apr.qvd cannot be found

[Kushal_Chawda]

try this

LET vLastMonth =num( Month(Today()-1),'00');

[kaushiknsolanki]

Hi,

You must use set variable as below.

LET vLastMonth = Year(Today())&'-'&Num(Month(Today()-1),'00');

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Try this: LET vLastMonth = MonthStart(Today(),-1),'YYYY-MM');

[#5]

Still getting current months data... 😕