topic Incremental issue in QlikView

Incremental issue

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

m_woolf — Tue, 14 Nov 2017 19:35:56 GMT

Don't see any Where clause in your script.

manu1512 — Tue, 14 Nov 2017 20:40:10 GMT

please see the new qvw file

vishsaggi — Tue, 14 Nov 2017 21:36:33 GMT

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