Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI there,
does anybody know how to solve the problem below?
Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.
Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.
id_code_dwlog | dt_date_order | 22/11/2010 | 23/11/2010 | 24/11/2010 | 25/11/2010 | 26/11/2010 | 29/11/2010 | 30/11/2010 | 01/12/2010 | ||
E1340607080 0807 | STK Beginning Period |
| 840 | 840 | 840 | 840 | 840 | 840 | 840 | ||
XXXX | DESIRED STOCK Beginning period EVOLUTION | 840 | 837 | 567 | 327 | 57 | -123 | -273 | -423 | ||
E1340607080 0807 | ORDERS | 3 | 270 | 240 | 270 | 180 | 150 | 150 | 270 | ||
XXXX | DESIRED STOCK End period EVOLUTION | 837 | 567 | 327 | 57 | -123 | -273 | -423 | -693 | ||
XXXX | DESIRED FULL DAYS OF COVERAGE | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | ||
IDENTIFYING STOCK OUT | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | |||
IDENTIFYING STOCK OUT DATE | FALSO | FALSO | FALSO | FALSO | 26/11/2010 | 29/11/2010 | 30/11/2010 | 01/12/2010 |
Try the example attached, Regards.
corrado
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/8625.stock-coverage.zip:550:0]