topic Historic Forward Sales in QlikView https://community.qlik.com/t5/QlikView/Historic-Forward-Sales/m-p/1898251#M1217639 <P>Hello,</P> <P>I'm trying to create a straight table to show me historic forward sales.</P> <P>I want to see the sum of Sales_QTY where the Order_Date is before a date and the Shipping_Date is after the date.</P> <P>Example: If the Order_Date is 2022-01-01 I want to sum all Sales_QTY where the Order_Date is smaller than 2022-01-01 and Shipping_Date is greater than 2022-01-01.</P> <P>DataSet:</P> <TABLE width="412"> <TBODY> <TR> <TD width="109">Order_ID</TD> <TD width="80">Order_Date</TD> <TD width="152">Shipping_Date</TD> <TD width="71">Sales_QTY</TD> </TR> <TR> <TD>12345</TD> <TD>2022-01-01</TD> <TD>2022-01-02</TD> <TD>12</TD> </TR> <TR> <TD>12346</TD> <TD>2022-01-01</TD> <TD>2022-01-05</TD> <TD>15</TD> </TR> <TR> <TD>12347</TD> <TD>2022-01-03</TD> <TD>2022-01-06</TD> <TD>24</TD> </TR> <TR> <TD>12348</TD> <TD>2022-01-03</TD> <TD>2022-01-09</TD> <TD>14</TD> </TR> <TR> <TD>12349</TD> <TD>2022-01-05</TD> <TD>2022-01-06</TD> <TD>3</TD> </TR> <TR> <TD>12350</TD> <TD>2022-01-05</TD> <TD>2022-01-08</TD> <TD>6</TD> </TR> <TR> <TD>12351</TD> <TD>2022-01-07</TD> <TD>2022-01-07</TD> <TD>14</TD> </TR> <TR> <TD>12352</TD> <TD>2022-01-07</TD> <TD>2022-01-10</TD> <TD>8</TD> </TR> <TR> <TD>12353</TD> <TD>2022-01-09</TD> <TD>2022-01-11</TD> <TD>15</TD> </TR> <TR> <TD>12354</TD> <TD>2022-01-09</TD> <TD>2022-01-10</TD> <TD>7</TD> </TR> <TR> <TD>12355</TD> <TD>2022-01-09</TD> <TD>2022-01-14</TD> <TD>6</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Desired Result:&nbsp;</P> <TABLE width="150"> <TBODY> <TR> <TD width="79">Order_Date</TD> <TD width="71">Sales_QTY</TD> </TR> <TR> <TD>2022-01-01</TD> <TD>0</TD> </TR> <TR> <TD>2022-01-03</TD> <TD>15</TD> </TR> <TR> <TD>2022-01-05</TD> <TD>38</TD> </TR> <TR> <TD>2022-01-07</TD> <TD>20</TD> </TR> <TR> <TD>2022-01-09</TD> <TD>8</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 28 Feb 2022 12:56:34 GMT Rust 2022-02-28T12:56:34Z Historic Forward Sales https://community.qlik.com/t5/QlikView/Historic-Forward-Sales/m-p/1898251#M1217639 <P>Hello,</P> <P>I'm trying to create a straight table to show me historic forward sales.</P> <P>I want to see the sum of Sales_QTY where the Order_Date is before a date and the Shipping_Date is after the date.</P> <P>Example: If the Order_Date is 2022-01-01 I want to sum all Sales_QTY where the Order_Date is smaller than 2022-01-01 and Shipping_Date is greater than 2022-01-01.</P> <P>DataSet:</P> <TABLE width="412"> <TBODY> <TR> <TD width="109">Order_ID</TD> <TD width="80">Order_Date</TD> <TD width="152">Shipping_Date</TD> <TD width="71">Sales_QTY</TD> </TR> <TR> <TD>12345</TD> <TD>2022-01-01</TD> <TD>2022-01-02</TD> <TD>12</TD> </TR> <TR> <TD>12346</TD> <TD>2022-01-01</TD> <TD>2022-01-05</TD> <TD>15</TD> </TR> <TR> <TD>12347</TD> <TD>2022-01-03</TD> <TD>2022-01-06</TD> <TD>24</TD> </TR> <TR> <TD>12348</TD> <TD>2022-01-03</TD> <TD>2022-01-09</TD> <TD>14</TD> </TR> <TR> <TD>12349</TD> <TD>2022-01-05</TD> <TD>2022-01-06</TD> <TD>3</TD> </TR> <TR> <TD>12350</TD> <TD>2022-01-05</TD> <TD>2022-01-08</TD> <TD>6</TD> </TR> <TR> <TD>12351</TD> <TD>2022-01-07</TD> <TD>2022-01-07</TD> <TD>14</TD> </TR> <TR> <TD>12352</TD> <TD>2022-01-07</TD> <TD>2022-01-10</TD> <TD>8</TD> </TR> <TR> <TD>12353</TD> <TD>2022-01-09</TD> <TD>2022-01-11</TD> <TD>15</TD> </TR> <TR> <TD>12354</TD> <TD>2022-01-09</TD> <TD>2022-01-10</TD> <TD>7</TD> </TR> <TR> <TD>12355</TD> <TD>2022-01-09</TD> <TD>2022-01-14</TD> <TD>6</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Desired Result:&nbsp;</P> <TABLE width="150"> <TBODY> <TR> <TD width="79">Order_Date</TD> <TD width="71">Sales_QTY</TD> </TR> <TR> <TD>2022-01-01</TD> <TD>0</TD> </TR> <TR> <TD>2022-01-03</TD> <TD>15</TD> </TR> <TR> <TD>2022-01-05</TD> <TD>38</TD> </TR> <TR> <TD>2022-01-07</TD> <TD>20</TD> </TR> <TR> <TD>2022-01-09</TD> <TD>8</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 28 Feb 2022 12:56:34 GMT https://community.qlik.com/t5/QlikView/Historic-Forward-Sales/m-p/1898251#M1217639 Rust 2022-02-28T12:56:34Z