Qlik Community

QlikView Documents

Documents for QlikView related information.

Load latest month Data from Quarter QVDs SalesYYYYQ0X format

Arjunarao
Honored Contributor II

Load latest month Data from Quarter QVDs SalesYYYYQ0X format

//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());

Labels (1)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎03-06-2018 04:52 AM
Updated by: