Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

STOCK DAYS OF COVERAGE, PIVOT PROBLEMS

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_dwlogdt_date_order22/11/201023/11/201024/11/201025/11/201026/11/201029/11/201030/11/201001/12/2010
E1340607080 0807STK Beginning Period
840
840840840840840840840
XXXXDESIRED STOCK Beginning period EVOLUTION84083756732757-123-273-423
E1340607080 0807ORDERS3270240270180150150270
XXXXDESIRED STOCK End period EVOLUTION83756732757-123-273-423-693
XXXXDESIRED FULL DAYS OF COVERAGE43210000
IDENTIFYING STOCK OUT11110000
IDENTIFYING STOCK OUT DATEFALSOFALSOFALSOFALSO26/11/201029/11/201030/11/201001/12/2010

Tags (1)
1 Reply
Not applicable

STOCK DAYS OF COVERAGE, PIVOT PROBLEMS

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]

Community Browser