PERFORM CALCULATION ON LOADED QVD FILE

[vikasmahajan]

Dear All,

I have following types of data in qvd vle  i want to calculate first stock in date as (today()- first stock in date) from the following qvd 

how to achive  from scripts , I thing we need to calculate days

Any help ?

Vikas

VLE:

load  * INLINE

   [item code, Valued Quantity,Entry_Type,Posting Date,Doc_Type

    RX001, 1200, 4, 01/07/2012,10

    RX999, 1500, 0, 01/08/2012,10

    RX001, 1000, 4, 01/05/2012,10

    RX001, 2000, 4, 01/04/2012,10

];

/

Store VLE into D:\xyz.qvd (qvd);

ValueEntry_IAL:

LOAD *,

   If(StockInOutIndicator = 1, Today() - Max([Posting Date]) ) AS [Exp Days Items];

LOAD *,

if([Valued Quantity] >= 0    AND

     ((Entry_Type = 0 AND Doc_Type = 5)

   OR (Entry_Type = 1 AND Doc_Type = 3)

   OR (Entry_Type = 2)

   OR (Entry_Type = 4 AND Doc_Type = 10)

   OR (Entry_Type = 4 AND Doc_Type = 0)

   OR (Entry_Type = 6)),1,0) AS StockInOutIndicator

FROM

(qvd);