Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manu1512
New Contributor III

Incremental issue

Hi all,

I am new to qlikview , i am practicing incremental load but after putting where condition i am getting a error field not found.

Can any one help please?

Pfa the files attached.

Regards

Manu

3 Replies
mwoolf
Honored Contributor II

Re: Incremental issue

Don't see any Where clause in your script.

manu1512
New Contributor III

Re: Incremental issue

please see the new qvw file

vishsaggi
Esteemed Contributor III

Re: Incremental issue

Try this

change the paths accordingly with your excel sheet and QVD paths.

Sales:

LOAD Customer,

[Sales Order ID],

Date#(ShipDate,'DD-MM-YYYY') AS ShipDate,

Product,

Sales, Quantity

FROM [..\Desktop\RoughForum_Files\Sales Orders .xls]

(biff, embedded labels, table is [Sales Orders$]);

Temp:

LOAD MAX( Num#(ShipDate)) as MaxDate

Resident Sales;

let vMaxDate = Peek('MaxDate',0,Temp);

TRACE >>> $(vMaxDate);

Store Sales into C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd(qvd);

DROP Table Sales;

Sales2:

LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity

FROM [..\Desktop\RoughForum_Files\Sales Orders .xls] (biff, embedded labels, table is [Sales Orders$])

where [ShipDate]>> $(vMaxDate);

Concatenate

LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity

FROM C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd (qvd);