Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Load latest month Data from Quarter QVDs SalesYYYYQ0X format

cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Load latest month Data from Quarter QVDs SalesYYYYQ0X format

Last Update:

Sep 21, 2022 5:11:51 PM

Updated By:

Sue_Macaluso

Created date:

Mar 6, 2018 4:52:33 AM

Attachments

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

Tags (1)
Labels (1)
Version history
Last update:
‎2022-09-21 05:11 PM
Updated by: