https://community.qlik.com/t5/QlikView/How-to-fill-the-dates/m-p/1789417#M1210437 <P>Hello All,</P><P>I need suggestions in getting below requirement.</P><P>I need to fill the dates in between&nbsp;&nbsp;<STRONG>ValidFrom</STRONG> and <STRONG>ValidTo</STRONG> dates</P><P>Example:</P><P>Part&nbsp; &nbsp; &nbsp;Supplier&nbsp; Plant&nbsp; &nbsp; &nbsp; &nbsp;Validfrom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValidTo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>the above is the sample data from which I need to derive a&nbsp;new&nbsp; column</P><P><STRONG>Required Output:</STRONG></P><P>Part&nbsp; &nbsp; &nbsp;Supplier&nbsp; Plant&nbsp; &nbsp; &nbsp; &nbsp;Validfrom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValidTo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp; &nbsp; NewColumn</STRONG></P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/04/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;. so on</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30/06/2020</P><P>&nbsp;</P> Tue, 09 Mar 2021 05:49:30 GMT kunkumnaveen 2021-03-09T05:49:30Z https://community.qlik.com/t5/QlikView/How-to-fill-the-dates/m-p/1789417#M1210437 <P>Hello All,</P><P>I need suggestions in getting below requirement.</P><P>I need to fill the dates in between&nbsp;&nbsp;<STRONG>ValidFrom</STRONG> and <STRONG>ValidTo</STRONG> dates</P><P>Example:</P><P>Part&nbsp; &nbsp; &nbsp;Supplier&nbsp; Plant&nbsp; &nbsp; &nbsp; &nbsp;Validfrom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValidTo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>the above is the sample data from which I need to derive a&nbsp;new&nbsp; column</P><P><STRONG>Required Output:</STRONG></P><P>Part&nbsp; &nbsp; &nbsp;Supplier&nbsp; Plant&nbsp; &nbsp; &nbsp; &nbsp;Validfrom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ValidTo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp; &nbsp; NewColumn</STRONG></P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04/04/2020</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/04/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;. so on</P><P>Screw&nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp;30/06/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30/06/2020</P><P>&nbsp;</P> Tue, 09 Mar 2021 05:49:30 GMT https://community.qlik.com/t5/QlikView/How-to-fill-the-dates/m-p/1789417#M1210437 kunkumnaveen 2021-03-09T05:49:30Z https://community.qlik.com/t5/QlikView/How-to-fill-the-dates/m-p/1789818#M1210496 <P>Maybe like this:</P><P>&nbsp;</P><LI-CODE lang="markup">TEST: LOAD * INLINE [ Part, Supplier, Plant, Validfrom, ValidTo, Price Screw, ABC, XYZ, 01/04/2020, 30/06/2020, 100 ]; NoConcatenate tmp: LOAD Part, Supplier, Plant, Validfrom, ValidTo, Validfrom + IterNo()-1 as Validfrom_New, Validfrom + IterNo()-1 as ValidTo_New, Price Resident TEST While Validfrom +IterNo()-1 &lt;= ValidTo; NoConcatenate Final: Load *, Date(ValidTo_New,'DD/MM/YYYY') as DateNew Resident tmp ; DROP Tables TEST,tmp</LI-CODE><P>&nbsp;</P> Tue, 09 Mar 2021 21:41:48 GMT https://community.qlik.com/t5/QlikView/How-to-fill-the-dates/m-p/1789818#M1210496 Frank_Hartmann 2021-03-09T21:41:48Z