https://community.qlik.com/t5/App-Development/How-To-generate-all-Dates-based-on-Random-dates-column/m-p/2501233#M103305 <P>Hi Team,&nbsp;</P> <P>We have requirement to generate all the dates a Date column based on the Random date column we have. See below the attached data:</P> <TABLE width="306"> <TBODY> <TR> <TD width="64">Id</TD> <TD width="178">Resource Date</TD> <TD width="64">Value</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>22-01-2024</TD> <TD>300</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>22-01-2024</TD> <TD>350</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The result/Output which is required is :&nbsp;</P> <TABLE width="540"> <TBODY> <TR> <TD width="64">Id</TD> <TD width="190">Resource Date</TD> <TD width="190">Date</TD> <TD width="96">Value</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>13-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>14-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>15-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>16-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>17-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>18-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>19-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>20-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>21-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>22-01-2024</TD> <TD>22-01-2024</TD> <TD>300</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>13-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>14-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>15-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>16-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>17-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>18-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>19-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>20-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>21-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>22-01-2024</TD> <TD>22-01-2024</TD> <TD>350</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please suggest how we can achieve the above result.</P> Tue, 14 Jan 2025 17:06:30 GMT Manish2109 2025-01-14T17:06:30Z https://community.qlik.com/t5/App-Development/How-To-generate-all-Dates-based-on-Random-dates-column/m-p/2501233#M103305 <P>Hi Team,&nbsp;</P> <P>We have requirement to generate all the dates a Date column based on the Random date column we have. See below the attached data:</P> <TABLE width="306"> <TBODY> <TR> <TD width="64">Id</TD> <TD width="178">Resource Date</TD> <TD width="64">Value</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>22-01-2024</TD> <TD>300</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>22-01-2024</TD> <TD>350</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The result/Output which is required is :&nbsp;</P> <TABLE width="540"> <TBODY> <TR> <TD width="64">Id</TD> <TD width="190">Resource Date</TD> <TD width="190">Date</TD> <TD width="96">Value</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>13-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>14-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>15-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>13-01-2024</TD> <TD>16-01-2024</TD> <TD>100</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>17-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>18-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>19-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>20-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>17-01-2024</TD> <TD>21-01-2024</TD> <TD>200</TD> </TR> <TR> <TD>201</TD> <TD>22-01-2024</TD> <TD>22-01-2024</TD> <TD>300</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>13-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>14-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>15-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>13-01-2024</TD> <TD>16-01-2024</TD> <TD>150</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>17-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>18-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>19-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>20-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>17-01-2024</TD> <TD>21-01-2024</TD> <TD>250</TD> </TR> <TR> <TD>401</TD> <TD>22-01-2024</TD> <TD>22-01-2024</TD> <TD>350</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please suggest how we can achieve the above result.</P> Tue, 14 Jan 2025 17:06:30 GMT https://community.qlik.com/t5/App-Development/How-To-generate-all-Dates-based-on-Random-dates-column/m-p/2501233#M103305 Manish2109 2025-01-14T17:06:30Z https://community.qlik.com/t5/App-Development/How-To-generate-all-Dates-based-on-Random-dates-column/m-p/2502136#M103423 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/216167">@Manish2109</a>&nbsp;Please refer below article.</P> <P><A href="https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637" target="_blank">https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637</A></P> Tue, 21 Jan 2025 06:25:03 GMT https://community.qlik.com/t5/App-Development/How-To-generate-all-Dates-based-on-Random-dates-column/m-p/2502136#M103423 Bhushan_Mahajan 2025-01-21T06:25:03Z