topic STOCK DAYS OF COVERAGE, PIVOT PROBLEMS in QlikView https://community.qlik.com/t5/QlikView/STOCK-DAYS-OF-COVERAGE-PIVOT-PROBLEMS/m-p/291268#M1202930 <HTML><HEAD></HEAD><BODY><P>HI there,<BR /><BR />does anybody know how to solve the problem below?<BR /><BR />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.<BR /><BR />Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="931"><COL style="width: 76pt;" width="101" /><COL style="width: 175pt;" width="233" /><COL style="width: 51pt;" width="68" /><COL span="4" style="width: 48pt;" width="64" /><COL style="width: 61pt;" width="81" /><COL span="3" style="width: 48pt;" width="64" /><TBODY><TR height="21" style="height: 15.75pt;"><TD class="xl66" height="21" style="height: 15.75pt; width: 76pt;" width="101">id_code_dwlog</TD><TD class="xl67" style="width: 175pt;" width="233">dt_date_order</TD><TD class="xl70" style="width: 51pt;" width="68"></TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">22/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">23/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">24/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">25/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 61pt;" width="81">26/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">29/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">30/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">01/12/2010</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;">E1340607080 0807</TD><TD class="xl68" style="border-left: medium none;">STK Beginning Period</TD><TD class="xl68" style="border-left: medium none;"></TD><TD align="left" valign="top"><TABLE cellpadding="0" cellspacing="0"><TBODY><TR><TD align="right" class="xl69" height="20" style="height: 15pt; border-top: medium none; border-left: medium none; width: 48pt;" width="64">840</TD></TR></TBODY></TABLE></TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED STOCK Beginning period EVOLUTION</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">837</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">567</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">327</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">57</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-123</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-273</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-423</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;">E1340607080 0807</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">ORDERS</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">240</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">180</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">150</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">150</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED STOCK End period EVOLUTION</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">837</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">567</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">327</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">57</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-123</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-273</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-423</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-693</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED FULL DAYS OF COVERAGE</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">4</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;"></TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">IDENTIFYING STOCK OUT</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;"></TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">IDENTIFYING STOCK OUT DATE</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"></TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">26/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">29/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">30/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">01/12/2010</TD></TR></TBODY></TABLE><P></P><P></P></BODY></HTML> Mon, 29 Nov 2010 17:35:46 GMT 2010-11-29T17:35:46Z STOCK DAYS OF COVERAGE, PIVOT PROBLEMS https://community.qlik.com/t5/QlikView/STOCK-DAYS-OF-COVERAGE-PIVOT-PROBLEMS/m-p/291268#M1202930 <HTML><HEAD></HEAD><BODY><P>HI there,<BR /><BR />does anybody know how to solve the problem below?<BR /><BR />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.<BR /><BR />Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="931"><COL style="width: 76pt;" width="101" /><COL style="width: 175pt;" width="233" /><COL style="width: 51pt;" width="68" /><COL span="4" style="width: 48pt;" width="64" /><COL style="width: 61pt;" width="81" /><COL span="3" style="width: 48pt;" width="64" /><TBODY><TR height="21" style="height: 15.75pt;"><TD class="xl66" height="21" style="height: 15.75pt; width: 76pt;" width="101">id_code_dwlog</TD><TD class="xl67" style="width: 175pt;" width="233">dt_date_order</TD><TD class="xl70" style="width: 51pt;" width="68"></TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">22/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">23/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">24/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">25/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 61pt;" width="81">26/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">29/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">30/11/2010</TD><TD class="xl68" style="border-left: medium none; width: 48pt;" width="64">01/12/2010</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;">E1340607080 0807</TD><TD class="xl68" style="border-left: medium none;">STK Beginning Period</TD><TD class="xl68" style="border-left: medium none;"></TD><TD align="left" valign="top"><TABLE cellpadding="0" cellspacing="0"><TBODY><TR><TD align="right" class="xl69" height="20" style="height: 15pt; border-top: medium none; border-left: medium none; width: 48pt;" width="64">840</TD></TR></TBODY></TABLE></TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">840</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED STOCK Beginning period EVOLUTION</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">840</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">837</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">567</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">327</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">57</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-123</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-273</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-423</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;">E1340607080 0807</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">ORDERS</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">240</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">180</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">150</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">150</TD><TD align="right" class="xl68" style="border-top: medium none; border-left: medium none;">270</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED STOCK End period EVOLUTION</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">837</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">567</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">327</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">57</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-123</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-273</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-423</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">-693</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl71" height="20" style="height: 15pt; border-top: medium none;">XXXX</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;">DESIRED FULL DAYS OF COVERAGE</TD><TD class="xl71" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">4</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">3</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">2</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl72" style="border-top: medium none; border-left: medium none;">0</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;"></TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">IDENTIFYING STOCK OUT</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;"></TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">1</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD><TD align="right" class="xl69" style="border-top: medium none; border-left: medium none;">0</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl68" height="20" style="height: 15pt; border-top: medium none;"></TD><TD class="xl68" style="border-top: medium none; border-left: medium none;">IDENTIFYING STOCK OUT DATE</TD><TD class="xl68" style="border-top: medium none; border-left: medium none;"></TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD align="center" class="xl69" style="border-top: medium none; border-left: medium none;">FALSO</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">26/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">29/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">30/11/2010</TD><TD class="xl69" style="border-top: medium none; border-left: medium none;">01/12/2010</TD></TR></TBODY></TABLE><P></P><P></P></BODY></HTML> Mon, 29 Nov 2010 17:35:46 GMT https://community.qlik.com/t5/QlikView/STOCK-DAYS-OF-COVERAGE-PIVOT-PROBLEMS/m-p/291268#M1202930 2010-11-29T17:35:46Z STOCK DAYS OF COVERAGE, PIVOT PROBLEMS https://community.qlik.com/t5/QlikView/STOCK-DAYS-OF-COVERAGE-PIVOT-PROBLEMS/m-p/291269#M1202931 <HTML><HEAD></HEAD><BODY><P>Try the example attached, Regards.</P><P>corrado</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/8625.stock-coverage.zip:550:0]</P></BODY></HTML> Wed, 16 Mar 2011 10:10:42 GMT https://community.qlik.com/t5/QlikView/STOCK-DAYS-OF-COVERAGE-PIVOT-PROBLEMS/m-p/291269#M1202931 2011-03-16T10:10:42Z