PERFORM CALCULATION ON LOADED QVD FILE

vikasmahajan — Sat, 13 Oct 2012 11:11:55 GMT

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

topic PERFORM CALCULATION ON LOADED QVD FILE in QlikView