Discussion board where members can get started with QlikView.
I have a stocktake file showing quantity in stock per item:
I have a file of Stock Received showing quantity received by date for each item
I want to age the items in stock in the stocktake file by listing the Stock Received trasnactions that make up thw stocktake quantity ie by making a new table like so:
So, the stocktake quantity for A is made up of the full receipt on 31-Mar and 05-Feb, and 1 of the quantity of 3 received 03-Jan.
Share answer of this problem