Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-11-29 12:35 PM

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

Labels (1)
Labels
COVERAGE_DAYS_PIVOT.xlsx
1,888 Views
0 Likes
1 Reply
Not applicable
‎2011-03-16 06:10 AM
Author

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]

503 Views
0 Likes