//Data load and store into QVD:
Let vQVD='Sales'&Year(Today())&num(ceil(month(Today())/3),'00');
SalesData:
LOAD InvoiceNumber, InvoiceLineNumber, InvoiceDate, CustomerID, SalesmanID, ProductID, Quantity,
Price, TotalPrice,'Sales'&Year(Today())&num(ceil(month(Today())/3),'00') as QVDName
FROM Data.xlsx (ooxml, embedded labels, table is Sheet2);
STORE SalesData into $(vQVD).qvd(qvd);
EXIT SCRIPT;
//Loading latest month Data from latest QVD:
Set vFolder = 'C:\Users\SUDHIKSHA\Desktop\Qlikview\';
load * ,QvdTableName('Sales'&Year(Today())&num(ceil(month(Today())/3),'00')&'.QVD') from [$(File)] (qvd)
Where month(InvoiceDate)=month(Today());