STOCK DAYS OF COVERAGE, PIVOT PROBLEMS

[#1]

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	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

[#2]

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]