topic Re: Previous Row Value in Script in QlikView

Previous Row Value in Script

Fri, 01 Aug 2014 13:51:56 GMT

Dear all,

kindly below my input and require output

Table Input

Output shoul be like than:

giakoum — Fri, 01 Aug 2014 14:00:42 GMT

How is output calculated? Please share some insight, we cannot read minds I am afraid...

marcus_malinow — Fri, 01 Aug 2014 14:18:55 GMT

Maybe this...

LOAD

Location,

Item,

LineID,

Days,

Req,

Available,

if (isnull(peek('Location', -1)) or peek('Location', -1) <> Location or peek('Item', -1) <> Item,

Available - Req,

peek('output', -1) - Req) as output

RESIDENT [Your Table]

Order by Location, Item, LineID