Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mazacini
Contributor III

Stock ageing

Hi

I have a stocktake file showing quantity in stock per item:

ItemStockQty
A5
B10
C7

I have a file of Stock Received showing quantity received by date for each item

DateItemRefQtyIn
03-JanA54973
05-FebA53462
31-MarA53862
05-MarB50293
12-AprB54425
15-MayB52897
12-FebC54013
08-MarC53341
09-AprC52675

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:

DateItemRefQtyIn
03-JanA54971
05-FebA53462
31-MarA53862
12-AprB54423
15-MayB52897
12-FebC54011
08-MarC53341
09-AprC52675

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.

1 Reply
Not applicable

Re: Stock ageing

Share answer of this problem

Community Browser