https://community.qlik.com/t5/QlikView/Consecutive-3-days-data-on-a-date-in-same-table/m-p/1817897#M1213172 <P>I have data like below . I need to show total order booked and total order billed for next 3 days on a date on key: Store Code&amp; Date&amp; Product Code&nbsp;</P><P>Table in model is like:</P><TABLE border="1"><TBODY><TR><TD>Store Code</TD><TD>Date</TD><TD>Product</TD><TD>Total Order Booked</TD><TD>Total Order Billed</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P1</TD><TD>10</TD><TD>8</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P2</TD><TD>12</TD><TD>10</TD></TR><TR><TD>ABC</TD><TD>18 June</TD><TD>P1</TD><TD>5</TD><TD>3</TD></TR><TR><TD>ABC</TD><TD>19 June</TD><TD>P1</TD><TD>7</TD><TD>5</TD></TR><TR><TD>ABC</TD><TD>20 June</TD><TD>P1</TD><TD>8</TD><TD>4</TD></TR><TR><TD>ABC</TD><TD>21 June</TD><TD>P1</TD><TD>6</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output :</P><TABLE border="1"><TBODY><TR><TD>Store Code</TD><TD>Date</TD><TD>Product</TD><TD>Total Order Booked&nbsp;</TD><TD>Total Order Booked for next 3 days excluding current date</TD><TD>Total Order Billed&nbsp;for next 3 days excluding current date</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P1</TD><TD>10</TD><TD>20</TD><TD>12</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P2</TD><TD>12</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE> Fri, 25 Jun 2021 11:39:44 GMT apoorva11 2021-06-25T11:39:44Z https://community.qlik.com/t5/QlikView/Consecutive-3-days-data-on-a-date-in-same-table/m-p/1817897#M1213172 <P>I have data like below . I need to show total order booked and total order billed for next 3 days on a date on key: Store Code&amp; Date&amp; Product Code&nbsp;</P><P>Table in model is like:</P><TABLE border="1"><TBODY><TR><TD>Store Code</TD><TD>Date</TD><TD>Product</TD><TD>Total Order Booked</TD><TD>Total Order Billed</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P1</TD><TD>10</TD><TD>8</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P2</TD><TD>12</TD><TD>10</TD></TR><TR><TD>ABC</TD><TD>18 June</TD><TD>P1</TD><TD>5</TD><TD>3</TD></TR><TR><TD>ABC</TD><TD>19 June</TD><TD>P1</TD><TD>7</TD><TD>5</TD></TR><TR><TD>ABC</TD><TD>20 June</TD><TD>P1</TD><TD>8</TD><TD>4</TD></TR><TR><TD>ABC</TD><TD>21 June</TD><TD>P1</TD><TD>6</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output :</P><TABLE border="1"><TBODY><TR><TD>Store Code</TD><TD>Date</TD><TD>Product</TD><TD>Total Order Booked&nbsp;</TD><TD>Total Order Booked for next 3 days excluding current date</TD><TD>Total Order Billed&nbsp;for next 3 days excluding current date</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P1</TD><TD>10</TD><TD>20</TD><TD>12</TD></TR><TR><TD>ABC</TD><TD>15 June</TD><TD>P2</TD><TD>12</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE> Fri, 25 Jun 2021 11:39:44 GMT https://community.qlik.com/t5/QlikView/Consecutive-3-days-data-on-a-date-in-same-table/m-p/1817897#M1213172 apoorva11 2021-06-25T11:39:44Z