https://community.qlik.com/t5/App-Development/Autofill/m-p/2515631#M105686 <P>Such task could be solved by deriving at first a Von-Bis range from the date and then the range is resolved to dedicated dates, for example with an approach like:</P><P>load *,&nbsp;date(Von + iterno() - 1) as FinalDate while Von + iterno() - 1 &lt;= Bis;<BR />load *,<BR />&nbsp; &nbsp;Datum as Von,<BR />&nbsp; &nbsp;if(Artikel &lt;&gt; previous(Artikel), today(), date(previous(Datum) - 1) as Bis<BR />resident Temp order by Artikel, Datum desc;</P><!-- end #ae_app --> Thu, 24 Apr 2025 11:29:09 GMT marcus_sommer 2025-04-24T11:29:09Z https://community.qlik.com/t5/App-Development/Autofill/m-p/2515617#M105684 <P>Hallo</P><P>Folgende Daten werden geladen.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Foesi12_0-1745486735996.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179888iE73C5C7F8B2785D6/image-size/medium?v=v2&amp;px=400" role="button" title="Foesi12_0-1745486735996.png" alt="Foesi12_0-1745486735996.png" /></span></P><P><BR />Das Ergebnis soll sein:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Foesi12_0-1745486545818.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179887i2272C7E18FC5186A/image-size/large?v=v2&amp;px=999" role="button" title="Foesi12_0-1745486545818.png" alt="Foesi12_0-1745486545818.png" /></span></P><P>&nbsp;</P><P>Gruss</P><!-- end #ae_app --> Thu, 24 Apr 2025 09:27:14 GMT https://community.qlik.com/t5/App-Development/Autofill/m-p/2515617#M105684 Foesi12 2025-04-24T09:27:14Z https://community.qlik.com/t5/App-Development/Autofill/m-p/2515631#M105686 <P>Such task could be solved by deriving at first a Von-Bis range from the date and then the range is resolved to dedicated dates, for example with an approach like:</P><P>load *,&nbsp;date(Von + iterno() - 1) as FinalDate while Von + iterno() - 1 &lt;= Bis;<BR />load *,<BR />&nbsp; &nbsp;Datum as Von,<BR />&nbsp; &nbsp;if(Artikel &lt;&gt; previous(Artikel), today(), date(previous(Datum) - 1) as Bis<BR />resident Temp order by Artikel, Datum desc;</P><!-- end #ae_app --> Thu, 24 Apr 2025 11:29:09 GMT https://community.qlik.com/t5/App-Development/Autofill/m-p/2515631#M105686 marcus_sommer 2025-04-24T11:29:09Z https://community.qlik.com/t5/App-Development/Autofill/m-p/2515640#M105688 <P>Hallo Marcus<BR />Ich schaue mir das das.<BR />Vielen Dank.</P><DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Thu, 24 Apr 2025 13:20:12 GMT https://community.qlik.com/t5/App-Development/Autofill/m-p/2515640#M105688 Foesi12 2025-04-24T13:20:12Z