Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecast report

Hi

I am trying to build up an inventory forecast report. I have three tables: there is current stock level in one, demand forecast in one (-->decrease inventory) and planned production orders (--> increase inventory). Demand forecast and planned production orders are by period.

What kind of script I need to come up with periodic inventories. (current inventory + cumulative production orders - cumulative demand)? Please see the example below.

       Current periodPeriod 1Period 2Period 3
Beginning inventory5000
Demand-2000-3000-1000
Production 050000
Periodic inventory300050004000

Thanks already beforehand!

Regards

Janne

0 Replies