I am trying to build lot size planning using inventory and demand in qlikview using the logic attached in excel. I m able to arrive at the formulae for few fields in load script but then there are many more fields which needs to be updated and correct the existing fields.
Can you check the script and the excel to arrive at possible solutions?
Are you looking to resolve this in the script? Also, when I try to run your script, I see an error saying that ClosingStock field is not found.... is one of the other fields supposed to be called ClosingStock within Plan_1 table?