topic Re: Generating QVd based on previously created QVD in QlikView

Generating QVd based on previously created QVD

deepakqlikview_123 — Mon, 19 May 2014 06:26:03 GMT

Hello Team,

Please find below data,

Dealer2:

LOAD DealerID,

DealerInvoiceID,

DealerInvoiceCode,

OutletID,

SerialNumber,

PurchaseOrderID,

VehicleID,

SubModelTypeID,

SubModelID,

DealerInvoiceDate,

ChassisNumber,

DeliveryID,

EngineNumber,

ColorID,

FinancerID,

TaxRelationShipID,

CustomerPurchaseOrderNumber,

IsDelivered,

IsDocsOK,

IsActive,

UnitPrice,

BasicAmount,

TypeOfCustomer,

PaymentDetails,

TypeOfInvoice,

CustomerID,

IsCancelled,

IsDeleted,

CreatedBy,

CreatedOn,

UpdatedBy,

UpdatedOn,

IsMigratedData,

IsIDMSMigratedData

FROM

E:\Piaggio\Distribution\Increamental\Data\VES_DealerInvoice.qvd

(qvd);

Now I would loke to generate ther QVD WHERE YEAR(DealerInvoiceDate) = 2014;

Can you please suggest hoe to do that.

Thanks

Re: Generating QVd based on previously created QVD

ashfaq_haseeb — Mon, 19 May 2014 06:30:06 GMT

Hi may be like this.