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.