topic Calculate order balance at specific time in QlikView https://community.qlik.com/t5/QlikView/Calculate-order-balance-at-specific-time/m-p/1569064#M741376 <P>Hi.</P><P>I have searched the community for days without finding what I need so now I hope for you guys <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>In order to deliver on time, we need to start order management no later than seven days after the order date. On the occasion of delays, I need to find out at what time (date or at least week) we are expected to start order processing on the seventh day (order date + 7). My data structure looks like this:</P><P>Balance</P><TABLE><TBODY><TR><TD>Date</TD><TD>Orderdate</TD><TD>Qty</TD><TD>Balance</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-26</TD><TD>44</TD><TD>44</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-27</TD><TD>766</TD><TD>810</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-28</TD><TD>680</TD><TD>1 490</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-29</TD><TD>622</TD><TD>2 112</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-30</TD><TD>91</TD><TD>2 203</TD></TR></TBODY></TABLE><P><BR />Production capacity</P><TABLE><TBODY><TR><TD>Date</TD><TD><P><SPAN>Capacity</SPAN></P></TD></TR><TR><TD>2019-04-15</TD><TD>963</TD></TR><TR><TD>2019-04-16</TD><TD>1 246</TD></TR><TR><TD>2019-04-17</TD><TD>1 246</TD></TR><TR><TD>2019-04-18</TD><TD>1 246</TD></TR><TR><TD>2019-04-19</TD><TD>963</TD></TR></TBODY></TABLE><P><BR />Expected new orders</P><TABLE><TBODY><TR><TD>Orderdate</TD><TD>Qty</TD></TR><TR><TD>2019-04-15</TD><TD>1 249</TD></TR><TR><TD>2019-04-16</TD><TD>1 186</TD></TR><TR><TD>2019-04-17</TD><TD>1 186</TD></TR><TR><TD>2019-04-18</TD><TD>1 249</TD></TR><TR><TD>2019-04-19</TD><TD>999</TD></TR></TBODY></TABLE><P><BR />I really appreciate all the help I can get.</P> Wed, 25 Nov 2020 16:16:04 GMT annanirvin 2020-11-25T16:16:04Z Calculate order balance at specific time https://community.qlik.com/t5/QlikView/Calculate-order-balance-at-specific-time/m-p/1569064#M741376 <P>Hi.</P><P>I have searched the community for days without finding what I need so now I hope for you guys <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>In order to deliver on time, we need to start order management no later than seven days after the order date. On the occasion of delays, I need to find out at what time (date or at least week) we are expected to start order processing on the seventh day (order date + 7). My data structure looks like this:</P><P>Balance</P><TABLE><TBODY><TR><TD>Date</TD><TD>Orderdate</TD><TD>Qty</TD><TD>Balance</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-26</TD><TD>44</TD><TD>44</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-27</TD><TD>766</TD><TD>810</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-28</TD><TD>680</TD><TD>1 490</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-29</TD><TD>622</TD><TD>2 112</TD></TR><TR><TD>2019-04-14</TD><TD>2019-03-30</TD><TD>91</TD><TD>2 203</TD></TR></TBODY></TABLE><P><BR />Production capacity</P><TABLE><TBODY><TR><TD>Date</TD><TD><P><SPAN>Capacity</SPAN></P></TD></TR><TR><TD>2019-04-15</TD><TD>963</TD></TR><TR><TD>2019-04-16</TD><TD>1 246</TD></TR><TR><TD>2019-04-17</TD><TD>1 246</TD></TR><TR><TD>2019-04-18</TD><TD>1 246</TD></TR><TR><TD>2019-04-19</TD><TD>963</TD></TR></TBODY></TABLE><P><BR />Expected new orders</P><TABLE><TBODY><TR><TD>Orderdate</TD><TD>Qty</TD></TR><TR><TD>2019-04-15</TD><TD>1 249</TD></TR><TR><TD>2019-04-16</TD><TD>1 186</TD></TR><TR><TD>2019-04-17</TD><TD>1 186</TD></TR><TR><TD>2019-04-18</TD><TD>1 249</TD></TR><TR><TD>2019-04-19</TD><TD>999</TD></TR></TBODY></TABLE><P><BR />I really appreciate all the help I can get.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-order-balance-at-specific-time/m-p/1569064#M741376 annanirvin 2020-11-25T16:16:04Z