Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
LET vLastMonth =num( Month(Today()-1),'00');
Hi,
You must use set variable as below.
LET vLastMonth = Year(Today())&'-'&Num(Month(Today()-1),'00');
Regards,
Kaushik Solanki
Try this: LET vLastMonth = MonthStart(Today(),-1),'YYYY-MM');
Still getting current months data... 😕