Lot size planning using existing data

[sathish_kumar]

Hello Qlik Users,

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?

thanks a lot

stalwar1‌

swuehl‌

[sunny_talwar]

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?

[sathish_kumar]

Hello Sunny,

I have done this part in the front end using charts.

Thanks a lot