QlikView's EXISTS() allows to check for a field already loaded.
In this case, you first load all those "Empid" you don't want to load. Then, you load all data except for those records where "Empid" equals to the ones already loaded. Third, you drop the table containing only the "Empid" not to load.
Take the following example:
DontLoad:LOAD * INLINE [EmpidABC]; Data:LOAD *FROM File.qvd (qvd)WHERE NOT EXISTS(Empid); DROP TABLE DontLoad;
This will load all records in File.qvd but those whose "Empid" has values "A", "B" or "C".
Hope that helps.
Full load required to generate qvd initially)
[VBAP - Order Items]:
VBELN & '/'& POSNR as [%VBELN/POSNR],
[MEINS] as [Base Unit_MEINS],
[MATKL] as [Material Group_MATKL],
[WERKS] as [Plant_WERKS],
[MATNR] as [Material_MATNR],
[SPART] as [Division_SPART],
[KPEIN] as [Pricing unit_KPEIN],
[KMEIN] as [Unit of measure_KMEIN],
[ERNAM] as [Created by_ERNAM],
[ERDAT] as [Created on_ERDAT],
[AEDAT] as [Changed on_AEDAT],
[POSNV] as [Item_POSNV],
[VSTEL] as [Shipping Point_VSTEL],
[VBELN] as [Sales Document_VBELN],
[POSNR] as [Item_POSNR],
[NETWR] as [Net value_NETWR];
SQL SELECT MEINS MATKL WERKS MATNR SPART KPEIN KMEIN ERNAM ERDAT AEDAT POSNV VSTEL VBELN NETWR POSNR
WHERE VBELN IN (
SELECT VBELN FROM VBAK // Order Header
WHERE ERDAT > '$(vLastReload)'
OR AEDAT > '$(vLastReload)'
CONCATENATE ([VBAP - Order Items])
FROM VBAP.qvd (qvd)
WHERE not exists ([%VBELN/POSNR]);