Discussion Board for collaboration on QlikView Scripting.
kindly below my input and require output
Output shoul be like than:
How is output calculated? Please share some insight, we cannot read minds I am afraid...
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