Stock on hand reporting problem

sangland2 — Mon, 02 Feb 2015 10:30:20 GMT

Hi, I have a problem which I'm hoping someone knows a good technique for. I have stock movement records in periods in which stock has moved with a resulting SOH figure on each record, eg

Stock:

LOAD * INLINE [

product,branch,PostingDate,onhand

F100,100,'31/10/14',100

F100,100,'29/10/14',102

F200,100,'28/09/15', 77

];

I want to report stock as at 31/1/15 (or any period) which is a calendar record by selecting the period. If there is no stock record, it needs to pick up the most recent priod stock movement record. Can this be done with Set analysis?

Joining the Calendar and Stock table would create a rather large table, but how to do this and then update the subsequent periods with the correct onhand figure?

Thanks.

topic Stock on hand reporting problem in QlikView

Stock on hand reporting problem