https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875390#M1216649 <P>Hi,</P> <P>I have this table and need to fill the date with gaps.</P> <P>This is my table</P> <TABLE width="752"> <TBODY> <TR> <TD width="119.75px" height="25px">ID</TD> <TD width="119.844px" height="25px">Start</TD> <TD width="151.719px" height="25px">End</TD> <TD width="119.797px" height="25px">Status</TD> <TD width="119.984px" height="25px">Status_Duration</TD> <TD width="119.906px" height="25px">Data_Date</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 6:00</TD> <TD width="151.719px" height="25px">11/2/2021 7:21</TD> <TD width="119.797px" height="25px">New Setup</TD> <TD width="119.984px" height="25px">1.35</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 7:21</TD> <TD width="151.719px" height="25px">11/2/2021 11:54</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">4.55</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 11:54</TD> <TD width="151.719px" height="25px">11/2/2021 14:27</TD> <TD width="119.797px" height="25px">Hold</TD> <TD width="119.984px" height="25px">2.55</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 14:27</TD> <TD width="151.719px" height="25px">11/2/2021 21:22</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">6.9</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 21:22</TD> <TD width="151.719px" height="25px">11/2/2021 23:03</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">1.7</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 23:03</TD> <TD width="151.719px" height="25px">11/3/2021 1:12</TD> <TD width="119.797px" height="25px">Setup</TD> <TD width="119.984px" height="25px">2.2</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 1:12</TD> <TD width="151.719px" height="25px">11/3/2021 6:00</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">4.8</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 6:00</TD> <TD width="151.719px" height="25px">11/3/2021 11:44</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">5.7</TD> <TD width="119.906px" height="25px">11/3/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 11:44</TD> <TD width="151.719px" height="25px">11/4/2021 6:00</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">18.3</TD> <TD width="119.906px" height="25px">11/3/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/6/2021 6:00</TD> <TD width="151.719px" height="25px">11/6/2021 10:34</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">4.6</TD> <TD width="119.906px" height="25px">11/6/2021</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>the table should look like below.</P> <TABLE width="594"> <TBODY> <TR> <TD width="46">ID</TD> <TD width="141">Start</TD> <TD width="141">End</TD> <TD width="88">Status</TD> <TD width="107">Status_Duration</TD> <TD width="71">Data_Date</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 6:00</TD> <TD>11/2/2021 7:21</TD> <TD>New Setup</TD> <TD>1.35</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 7:21</TD> <TD>11/2/2021 11:54</TD> <TD>Running</TD> <TD>4.55</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 11:54</TD> <TD>11/2/2021 14:27</TD> <TD>Hold</TD> <TD>2.55</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 14:27</TD> <TD>11/2/2021 21:22</TD> <TD>Running</TD> <TD>6.9</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 21:22</TD> <TD>11/2/2021 23:03</TD> <TD>Idle</TD> <TD>1.7</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 23:03</TD> <TD>11/3/2021 1:12</TD> <TD>Setup</TD> <TD>2.2</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 1:12</TD> <TD>11/3/2021 6:00</TD> <TD>Running</TD> <TD>4.8</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 6:00</TD> <TD>11/3/2021 11:44</TD> <TD>Running</TD> <TD>5.7</TD> <TD>11/3/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 11:44</TD> <TD>11/4/2021 6:00</TD> <TD>Idle</TD> <TD>18.3</TD> <TD>11/3/2021</TD> </TR> <TR> <TD><STRONG>1QPTS</STRONG></TD> <TD><STRONG>11/4/2021 6:00</STRONG></TD> <TD><STRONG>11/5/2021 6:00</STRONG></TD> <TD><STRONG>Idle</STRONG></TD> <TD><STRONG>24.0</STRONG></TD> <TD><STRONG>11/4/2021</STRONG></TD> </TR> <TR> <TD><STRONG>1QPTS</STRONG></TD> <TD><STRONG>11/5/2021 6:00</STRONG></TD> <TD><STRONG>11/6/2021 6:00</STRONG></TD> <TD><STRONG>Idle</STRONG></TD> <TD><STRONG>24.0</STRONG></TD> <TD><STRONG>11/5/2021</STRONG></TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/6/2021 6:00</TD> <TD>11/6/2021 10:34</TD> <TD>Idle</TD> <TD>4.6</TD> <TD>11/6/2021</TD> </TR> </TBODY> </TABLE> Tue, 28 Dec 2021 01:04:22 GMT overclocked 2021-12-28T01:04:22Z https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875390#M1216649 <P>Hi,</P> <P>I have this table and need to fill the date with gaps.</P> <P>This is my table</P> <TABLE width="752"> <TBODY> <TR> <TD width="119.75px" height="25px">ID</TD> <TD width="119.844px" height="25px">Start</TD> <TD width="151.719px" height="25px">End</TD> <TD width="119.797px" height="25px">Status</TD> <TD width="119.984px" height="25px">Status_Duration</TD> <TD width="119.906px" height="25px">Data_Date</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 6:00</TD> <TD width="151.719px" height="25px">11/2/2021 7:21</TD> <TD width="119.797px" height="25px">New Setup</TD> <TD width="119.984px" height="25px">1.35</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 7:21</TD> <TD width="151.719px" height="25px">11/2/2021 11:54</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">4.55</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 11:54</TD> <TD width="151.719px" height="25px">11/2/2021 14:27</TD> <TD width="119.797px" height="25px">Hold</TD> <TD width="119.984px" height="25px">2.55</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 14:27</TD> <TD width="151.719px" height="25px">11/2/2021 21:22</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">6.9</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 21:22</TD> <TD width="151.719px" height="25px">11/2/2021 23:03</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">1.7</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/2/2021 23:03</TD> <TD width="151.719px" height="25px">11/3/2021 1:12</TD> <TD width="119.797px" height="25px">Setup</TD> <TD width="119.984px" height="25px">2.2</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 1:12</TD> <TD width="151.719px" height="25px">11/3/2021 6:00</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">4.8</TD> <TD width="119.906px" height="25px">11/2/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 6:00</TD> <TD width="151.719px" height="25px">11/3/2021 11:44</TD> <TD width="119.797px" height="25px">Running</TD> <TD width="119.984px" height="25px">5.7</TD> <TD width="119.906px" height="25px">11/3/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/3/2021 11:44</TD> <TD width="151.719px" height="25px">11/4/2021 6:00</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">18.3</TD> <TD width="119.906px" height="25px">11/3/2021</TD> </TR> <TR> <TD width="119.75px" height="25px">1QPTS</TD> <TD width="119.844px" height="25px">11/6/2021 6:00</TD> <TD width="151.719px" height="25px">11/6/2021 10:34</TD> <TD width="119.797px" height="25px">Idle</TD> <TD width="119.984px" height="25px">4.6</TD> <TD width="119.906px" height="25px">11/6/2021</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>the table should look like below.</P> <TABLE width="594"> <TBODY> <TR> <TD width="46">ID</TD> <TD width="141">Start</TD> <TD width="141">End</TD> <TD width="88">Status</TD> <TD width="107">Status_Duration</TD> <TD width="71">Data_Date</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 6:00</TD> <TD>11/2/2021 7:21</TD> <TD>New Setup</TD> <TD>1.35</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 7:21</TD> <TD>11/2/2021 11:54</TD> <TD>Running</TD> <TD>4.55</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 11:54</TD> <TD>11/2/2021 14:27</TD> <TD>Hold</TD> <TD>2.55</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 14:27</TD> <TD>11/2/2021 21:22</TD> <TD>Running</TD> <TD>6.9</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 21:22</TD> <TD>11/2/2021 23:03</TD> <TD>Idle</TD> <TD>1.7</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/2/2021 23:03</TD> <TD>11/3/2021 1:12</TD> <TD>Setup</TD> <TD>2.2</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 1:12</TD> <TD>11/3/2021 6:00</TD> <TD>Running</TD> <TD>4.8</TD> <TD>11/2/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 6:00</TD> <TD>11/3/2021 11:44</TD> <TD>Running</TD> <TD>5.7</TD> <TD>11/3/2021</TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/3/2021 11:44</TD> <TD>11/4/2021 6:00</TD> <TD>Idle</TD> <TD>18.3</TD> <TD>11/3/2021</TD> </TR> <TR> <TD><STRONG>1QPTS</STRONG></TD> <TD><STRONG>11/4/2021 6:00</STRONG></TD> <TD><STRONG>11/5/2021 6:00</STRONG></TD> <TD><STRONG>Idle</STRONG></TD> <TD><STRONG>24.0</STRONG></TD> <TD><STRONG>11/4/2021</STRONG></TD> </TR> <TR> <TD><STRONG>1QPTS</STRONG></TD> <TD><STRONG>11/5/2021 6:00</STRONG></TD> <TD><STRONG>11/6/2021 6:00</STRONG></TD> <TD><STRONG>Idle</STRONG></TD> <TD><STRONG>24.0</STRONG></TD> <TD><STRONG>11/5/2021</STRONG></TD> </TR> <TR> <TD>1QPTS</TD> <TD>11/6/2021 6:00</TD> <TD>11/6/2021 10:34</TD> <TD>Idle</TD> <TD>4.6</TD> <TD>11/6/2021</TD> </TR> </TBODY> </TABLE> Tue, 28 Dec 2021 01:04:22 GMT https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875390#M1216649 overclocked 2021-12-28T01:04:22Z https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875710#M1216662 <P>Have a look on below sample</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/fill-out-missing-dates/td-p/1762804" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/fill-out-missing-dates/td-p/1762804</A></P> <P>&nbsp;</P> Wed, 29 Dec 2021 05:19:14 GMT https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875710#M1216662 Chanty4u 2021-12-29T05:19:14Z https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875837#M1216665 <P>maybe also helpful:</P> <P><A href="https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/bc-p/1470677" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/bc-p/1470677</A></P> <P>&nbsp;</P> Wed, 29 Dec 2021 11:44:50 GMT https://community.qlik.com/t5/QlikView/Fill-date-gaps-with-last-status/m-p/1875837#M1216665 MarcoWedel 2021-12-29T11:44:50Z