topic Monthly QVDs in QlikView

Monthly QVDs

Tue, 05 Apr 2016 08:26:11 GMT

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

Re: Monthly QVDs

Kushal_Chawda — Tue, 05 Apr 2016 08:28:34 GMT

try this

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

Re: Monthly QVDs

kaushiknsolanki — Tue, 05 Apr 2016 08:28:52 GMT

Hi,

You must use set variable as below.

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

Regards,

Kaushik Solanki

Re: Monthly QVDs

Gysbert_Wassenaar — Tue, 05 Apr 2016 08:30:01 GMT

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

Re: Monthly QVDs

Tue, 05 Apr 2016 08:56:01 GMT

Still getting current months data... 😕