Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

Monthly Stock Expression in straight table


i need to create a straight table with each shop location and the monthly amount of stock that remains.  i have the total amount [DEMAND_INV] that the stores require each month[MONTH] and the current inventory[AMOUNT].

e.g. july stock level needs to be 5

aug = 5

sept = 10

oct = 15

the current inv = 15, so therefore the store has 2.5 months of stock left. was wondering if anyone had any suggestions as to a good way of carrying out this calculation in QlikView.  naturally i need this value to dynamically change as the months roll on.

any advice is highly appreciated