Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
One of my QlikView job starts at Monday midnight and ends on Tuesday Morning .
I have a script to store into qvd year wise using a loop, so on Tuesday morning the last file gets stored,
I doubt that when the last file is getting stored, the vDate variable changes to Tuesday date not the monday date. is that true ? I want one single date always. does the below code work, please suggest.
Eg.
Let vDate = reloadtime();
//or
Let vDate = now();
For i = 2018 to 2020
Test:
Load * from tabl1;
Store Test into Test$(i)_$(vDate).qvd(qvd);
next ;
Out should be
Test2018_12-15-2020.qvd
Test2019_12-15-2020.qvd
Test2020_12-15-2020.qvd.
Thanks
Renjith
Maybe setting the mode-parameter of the date-function explicitly is an option, means something like:
let vDate = today(2);
- Marcus
Maybe setting the mode-parameter of the date-function explicitly is an option, means something like:
let vDate = today(2);
- Marcus