topic Fill In Missing Data in App Development https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2128748#M91812 <P>Hello Qlik Community</P> <P>I have a requirement where I have to add missing dates (Weekends) and show Fridays measure value for Weekends in a straight table as shown below</P> <P>Original Straight Table Data</P> <TABLE width="125"> <TBODY> <TR> <TD width="61">Date</TD> <TD width="64">sum(Sales)</TD> </TR> <TR> <TD>1/2/2023</TD> <TD>20</TD> </TR> <TR> <TD>1/3/2023</TD> <TD>30</TD> </TR> <TR> <TD>1/4/2023</TD> <TD>10</TD> </TR> <TR> <TD>1/5/2023</TD> <TD>25</TD> </TR> <TR> <TD>1/6/2023</TD> <TD>40</TD> </TR> <TR> <TD>1/9/2023</TD> <TD>60</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Required&nbsp;</P> <TABLE width="155px"> <TBODY> <TR> <TD width="69.8594px">Date</TD> <TD width="84.6719px">sum(Sales)</TD> </TR> <TR> <TD width="69.8594px">1/2/2023</TD> <TD width="84.6719px">20</TD> </TR> <TR> <TD width="69.8594px">1/3/2023</TD> <TD width="84.6719px">30</TD> </TR> <TR> <TD width="69.8594px">1/4/2023</TD> <TD width="84.6719px">10</TD> </TR> <TR> <TD width="69.8594px">1/5/2023</TD> <TD width="84.6719px">25</TD> </TR> <TR> <TD width="69.8594px">1/6/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/7/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/8/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/9/2023</TD> <TD width="84.6719px">60</TD> </TR> </TBODY> </TABLE> Mon, 16 Oct 2023 11:36:29 GMT Deepak13 2023-10-16T11:36:29Z Fill In Missing Data https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2128748#M91812 <P>Hello Qlik Community</P> <P>I have a requirement where I have to add missing dates (Weekends) and show Fridays measure value for Weekends in a straight table as shown below</P> <P>Original Straight Table Data</P> <TABLE width="125"> <TBODY> <TR> <TD width="61">Date</TD> <TD width="64">sum(Sales)</TD> </TR> <TR> <TD>1/2/2023</TD> <TD>20</TD> </TR> <TR> <TD>1/3/2023</TD> <TD>30</TD> </TR> <TR> <TD>1/4/2023</TD> <TD>10</TD> </TR> <TR> <TD>1/5/2023</TD> <TD>25</TD> </TR> <TR> <TD>1/6/2023</TD> <TD>40</TD> </TR> <TR> <TD>1/9/2023</TD> <TD>60</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Required&nbsp;</P> <TABLE width="155px"> <TBODY> <TR> <TD width="69.8594px">Date</TD> <TD width="84.6719px">sum(Sales)</TD> </TR> <TR> <TD width="69.8594px">1/2/2023</TD> <TD width="84.6719px">20</TD> </TR> <TR> <TD width="69.8594px">1/3/2023</TD> <TD width="84.6719px">30</TD> </TR> <TR> <TD width="69.8594px">1/4/2023</TD> <TD width="84.6719px">10</TD> </TR> <TR> <TD width="69.8594px">1/5/2023</TD> <TD width="84.6719px">25</TD> </TR> <TR> <TD width="69.8594px">1/6/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/7/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/8/2023</TD> <TD width="84.6719px">40</TD> </TR> <TR> <TD width="69.8594px">1/9/2023</TD> <TD width="84.6719px">60</TD> </TR> </TBODY> </TABLE> Mon, 16 Oct 2023 11:36:29 GMT https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2128748#M91812 Deepak13 2023-10-16T11:36:29Z Re: Fill In Missing Data https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2128753#M91813 <P>If you have calendar script you could left join the date backs to to fill the gaps and then use PEEK or Pervious() function to fill the gaps.&nbsp;</P> <P><A href="https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Peek.htm" target="_blank">https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Peek.htm</A></P> <P>&nbsp;</P> Mon, 16 Oct 2023 11:43:52 GMT https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2128753#M91813 Mark_Little 2023-10-16T11:43:52Z Re: Fill In Missing Data https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2129342#M91843 <P>maybe helpful:</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/t5/Member-Articles/Generating-Missing-Data-In-QlikView/ta-p/1491394" target="_blank">https://community.qlik.com/t5/Member-Articles/Generating-Missing-Data-In-QlikView/ta-p/1491394</A></P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlik-communityarticles/1906/1/Generating%20missing%20data.pdf" target="_blank">https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlik-communityarticles/1906/1/Generating%20missing%20data.pdf</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 17 Oct 2023 19:52:07 GMT https://community.qlik.com/t5/App-Development/Fill-In-Missing-Data/m-p/2129342#M91843 MarcoWedel 2023-10-17T19:52:07Z