topic Pivot table, offset, days stock coverage in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290269#M1203676 <HTML><HEAD></HEAD><BODY><P>HI there,</P><P>does anybody know how to solve the problem below?</P><P>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.</P><P>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" style="width: 692pt; border-collapse: collapse;" width="918"><COLGROUP><COL style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;" width="27" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913; mso-outline-parent: collapsed;" width="107" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl70" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; width: 20pt; height: 12.75pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="27">A</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">B</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 80pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="107">C</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">D</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">E</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">F</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">G</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">H</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">I</TD><TD class="xl72" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid;" width="98"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>id_code_dwlog</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>dt_date_order</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">24/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">25/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">26/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">29/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">30/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">01/12/2010</TD><TD class="xl73" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">02/12/2010</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">STOCK</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl74" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">1.000</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">ORDERS</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">250</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">250</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl73" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">200</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">STOCK-ORDERS</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">800</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">600</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">690</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">810</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">810</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">630</TD><TD align="right" class="xl75" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;">600</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">6</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl79" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">DESIRED RESULT 1</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">800</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">350</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">-100</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">-300</TD><TD align="right" class="xl81" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 1pt solid;">-500</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">EXCEL FORMULA</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=D3-D4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=D6-E4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=E6-F4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=F6-G4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=G6-H4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=H6-I4</TD><TD class="xl84" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;">ETC... ETC….</TD></TR><TR height="18" style="height: 13.5pt;"><TD class="xl83" height="18" style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 13.5pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl77" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">DESIRED RESULT 2</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl78" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thank in advance for any ideas or help.</P><P>Axo</P><P></P></BODY></HTML> Thu, 25 Nov 2010 00:03:44 GMT 2010-11-25T00:03:44Z Pivot table, offset, days stock coverage https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290269#M1203676 <HTML><HEAD></HEAD><BODY><P>HI there,</P><P>does anybody know how to solve the problem below?</P><P>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.</P><P>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" style="width: 692pt; border-collapse: collapse;" width="918"><COLGROUP><COL style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;" width="27" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913; mso-outline-parent: collapsed;" width="107" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl70" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; width: 20pt; height: 12.75pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="27">A</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">B</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 80pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="107">C</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">D</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">E</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">F</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">G</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">H</TD><TD class="xl71" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 0.5pt solid;" width="98">I</TD><TD class="xl72" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 74pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid;" width="98"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>id_code_dwlog</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>dt_date_order</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">24/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">25/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">26/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">29/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">30/11/2010</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">01/12/2010</TD><TD class="xl73" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">02/12/2010</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">STOCK</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">1.000</TD><TD align="right" class="xl74" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">1.000</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">ORDERS</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">250</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">250</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl73" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 1pt solid;">200</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">5</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">STOCK-ORDERS</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">800</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">600</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">690</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">810</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">810</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">630</TD><TD align="right" class="xl75" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;">600</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">6</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">CODE A</TD><TD class="xl79" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">DESIRED RESULT 1</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">800</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">350</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">-100</TD><TD align="right" class="xl80" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 0.5pt solid;">-300</TD><TD align="right" class="xl81" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; border-top: windowtext; border-right: windowtext 1pt solid;">-500</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl82" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">7</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">EXCEL FORMULA</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=D3-D4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=D6-E4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=E6-F4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=F6-G4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=G6-H4</TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">=H6-I4</TD><TD class="xl84" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;">ETC... ETC….</TD></TR><TR height="18" style="height: 13.5pt;"><TD class="xl83" height="18" style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; background-color: transparent; height: 13.5pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl77" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;">DESIRED RESULT 2</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl76" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD class="xl78" style="border-bottom: windowtext 1pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 1pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Thank in advance for any ideas or help.</P><P>Axo</P><P></P></BODY></HTML> Thu, 25 Nov 2010 00:03:44 GMT https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290269#M1203676 2010-11-25T00:03:44Z Pivot table, offset, days stock coverage https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290270#M1203677 <HTML><HEAD></HEAD><BODY><P>Would be easier if you could upload an excel with the date &amp; the desired results</P></BODY></HTML> Thu, 25 Nov 2010 12:53:28 GMT https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290270#M1203677 2010-11-25T12:53:28Z Pivot table, offset, days stock coverage https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290271#M1203678 <HTML><HEAD></HEAD><BODY><P>added,</P><P></P><P>thank you for your time</P></BODY></HTML> Thu, 25 Nov 2010 14:33:28 GMT https://community.qlik.com/t5/QlikView/Pivot-table-offset-days-stock-coverage/m-p/290271#M1203678 2010-11-25T14:33:28Z