topic load script in App Development https://community.qlik.com/t5/App-Development/load-script/m-p/2076264#M88349 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hello,<BR />I want to create a new field in the load script that adds up values. But only up to a certain range (same RMNr)</SPAN></PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>table1: <BR />LOAD AufS, <BR />Endtermin, <BR />RMNr, <BR />fert, <BR />Ressource, <BR />Teil, <BR />HBA, <BR />BABf, <BR />Solltermin, <BR />Deckungsmenge, <BR />Bedarfsmenge, <BR />Termin<BR />FROM<BR />........<BR />(txt, utf8, embedded labels, delimiter is ';', msq);</P> <P>&nbsp;</P> <P><BR />final:</P> <P>Noconcatenate Load<BR />RMNr, <BR />AufS, <BR />Endtermin, <BR />fert, <BR />Ressource, <BR />Teil, <BR />HBA, <BR />BABf, <BR />Solltermin, <BR />Deckungsmenge, <BR />Bedarfsmenge, <BR />Termin, <BR />If(Previous(RMNr) = (RMNr),(Deckungsmenge-Bedarfsmenge+If(rowno()=1,0,Peek(Stock)))) as Stock&nbsp;&nbsp; <BR /><BR /></P> <P><BR />Resident table1</P> <P>Order by Teil</P> <P>;</P> <P><BR />Drop table table1;</P> <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">the source table<BR /><BR /></SPAN></PRE> <TABLE style="border-collapse: collapse; width: 720pt;" border="0" width="960" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="80" height="20" style="height: 15.0pt; width: 60pt;">AufS</TD> <TD width="80" style="width: 60pt;">Endtermin</TD> <TD width="80" style="width: 60pt;">RMNr</TD> <TD width="80" style="width: 60pt;">fert</TD> <TD width="80" style="width: 60pt;">Ressource</TD> <TD width="80" style="width: 60pt;">Teil</TD> <TD width="80" style="width: 60pt;">HBA</TD> <TD width="80" style="width: 60pt;">BABf</TD> <TD width="80" style="width: 60pt;">Solltermin</TD> <TD width="80" style="width: 60pt;">Deckungsmenge</TD> <TD width="80" style="width: 60pt;">Bedarfsmenge</TD> <TD width="80" style="width: 60pt;">Termin</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31112</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31112</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31207</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31207</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>nein</TD> <TD>R31310</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>nein</TD> <TD>R31310</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">20.02.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">10.02.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">28.09.2023</TD> <TD align="right">854732</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2241UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">26.01.2023</TD> <TD align="right">3</TD> <TD align="right">0</TD> <TD align="right" class="xl63">26.05.2023</TD> </TR> </TBODY> </TABLE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">&nbsp;</SPAN></PRE> <P>&nbsp;</P> Fri, 15 Nov 2024 21:46:02 GMT MD6 2024-11-15T21:46:02Z load script https://community.qlik.com/t5/App-Development/load-script/m-p/2076264#M88349 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">Hello,<BR />I want to create a new field in the load script that adds up values. But only up to a certain range (same RMNr)</SPAN></PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>table1: <BR />LOAD AufS, <BR />Endtermin, <BR />RMNr, <BR />fert, <BR />Ressource, <BR />Teil, <BR />HBA, <BR />BABf, <BR />Solltermin, <BR />Deckungsmenge, <BR />Bedarfsmenge, <BR />Termin<BR />FROM<BR />........<BR />(txt, utf8, embedded labels, delimiter is ';', msq);</P> <P>&nbsp;</P> <P><BR />final:</P> <P>Noconcatenate Load<BR />RMNr, <BR />AufS, <BR />Endtermin, <BR />fert, <BR />Ressource, <BR />Teil, <BR />HBA, <BR />BABf, <BR />Solltermin, <BR />Deckungsmenge, <BR />Bedarfsmenge, <BR />Termin, <BR />If(Previous(RMNr) = (RMNr),(Deckungsmenge-Bedarfsmenge+If(rowno()=1,0,Peek(Stock)))) as Stock&nbsp;&nbsp; <BR /><BR /></P> <P><BR />Resident table1</P> <P>Order by Teil</P> <P>;</P> <P><BR />Drop table table1;</P> <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">the source table<BR /><BR /></SPAN></PRE> <TABLE style="border-collapse: collapse; width: 720pt;" border="0" width="960" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="80" height="20" style="height: 15.0pt; width: 60pt;">AufS</TD> <TD width="80" style="width: 60pt;">Endtermin</TD> <TD width="80" style="width: 60pt;">RMNr</TD> <TD width="80" style="width: 60pt;">fert</TD> <TD width="80" style="width: 60pt;">Ressource</TD> <TD width="80" style="width: 60pt;">Teil</TD> <TD width="80" style="width: 60pt;">HBA</TD> <TD width="80" style="width: 60pt;">BABf</TD> <TD width="80" style="width: 60pt;">Solltermin</TD> <TD width="80" style="width: 60pt;">Deckungsmenge</TD> <TD width="80" style="width: 60pt;">Bedarfsmenge</TD> <TD width="80" style="width: 60pt;">Termin</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31112</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31112</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31207</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>ja</TD> <TD>R31207</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>nein</TD> <TD>R31310</TD> <TD>680115 6906</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">2</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">25.05.2023</TD> <TD align="right">883262</TD> <TD>nein</TD> <TD>R31310</TD> <TD>680115 6906</TD> <TD>U</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">20.02.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">10.02.2023</TD> <TD align="right">1</TD> <TD align="right">0</TD> <TD align="right" class="xl63">25.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">10.10.2023</TD> <TD align="right">843846</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2131UL</TD> <TD>PPA</TD> <TD>U</TD> <TD align="right" class="xl63">23.05.2023</TD> <TD align="right">0</TD> <TD align="right">1</TD> <TD align="right" class="xl63">23.05.2023</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">in Fertigung</TD> <TD align="right" class="xl63">28.09.2023</TD> <TD align="right">854732</TD> <TD>nein</TD> <TD>R33001</TD> <TD>250063 2241UL</TD> <TD>PPA</TD> <TD>&nbsp;</TD> <TD align="right" class="xl63">26.01.2023</TD> <TD align="right">3</TD> <TD align="right">0</TD> <TD align="right" class="xl63">26.05.2023</TD> </TR> </TBODY> </TABLE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" style="unicode-bidi: isolate; font-size: 28px; line-height: 36px; background-color: #f8f9fa; border: none; padding: 2px 0.14em 2px 0px; position: relative; margin: -2px 0px; resize: none; font-family: inherit; overflow: hidden; text-align: left; width: 270px; white-space: pre-wrap; overflow-wrap: break-word; color: #202124; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-placeholder="Übersetzung"><SPAN class="Y2IQFc">&nbsp;</SPAN></PRE> <P>&nbsp;</P> Fri, 15 Nov 2024 21:46:02 GMT https://community.qlik.com/t5/App-Development/load-script/m-p/2076264#M88349 MD6 2024-11-15T21:46:02Z