Discussion Board for collaboration related to Creating Analytics for QlikView.
I have weekly sales file. one file per week. Every week will have new sales file. they all are qvd format.
What syntax I may use to just load the new created file weekly? Thanks.
Go to Solution.
check the partial reload in QV help
or in another case use a binary load while concatenating the new file
if you use a standard format for the weekly file naming it could be like
binary test.qvw // has to be first line of the whole script
let vWeekFormat = date(Today(),'YYYYMMDD');
What is the file name format?
You can use 'filetime()' function in the script.
from QlikView online help
Returns the XML-header time stamp from a QVD file if any (otherwise NULL).
The filename is the name of a QVD file, if necessary including path.
FilePath() as FilePath
,FileTime() as Filetime
FROM (qvd) ;
Load FilePath as File
Resident T1 Order by Filetime desc
; /// This variable will return Latest file info
Let vFile = Peek('File',0,'T2');
Drop Tables T1,T2;
/// Pass this variable to Qvd load