topic Re: Apply value to next record in QlikView https://community.qlik.com/t5/QlikView/Apply-value-to-next-record/m-p/2492096#M1226252 <P>Maybe in this way:</P> <P>m: mapping load distinct RelevantKey, Quantity from X where Quantity &gt; 0;</P> <P>t. load *, applymap('m',&nbsp;RelevantKey, '#NV') as QuantityNew from X,</P> Mon, 11 Nov 2024 15:21:40 GMT marcus_sommer 2024-11-11T15:21:40Z Apply value to next record https://community.qlik.com/t5/QlikView/Apply-value-to-next-record/m-p/2492089#M1226251 <P>Hello everyone,</P> <P>we are defining our budget for one cost element which is the same budget quantity for all other cost element by date, company code, plant and profit center.</P> <P>Unfortunetely for the other cost elements the budget quantity is 0 which needs the value of the first defined budget quantity. See below my data</P> <TABLE width="946"> <TBODY> <TR> <TD width="119.516px">_KEY_Date_ID</TD> <TD width="192.438px">_KEY_CompanyCode_ID</TD> <TD width="122.188px">_KEY_Plant_ID</TD> <TD width="171.078px">_KEY_ProfitCenter_ID</TD> <TD width="177.312px">_KEY_CostElement_ID</TD> <TD width="47.4688px">Base Unit</TD> <TD width="70.5938px">Quantity</TD> <TD width="73.2812px">Betrag</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|0003100200</TD> <TD width="47.4688px">M3</TD> <TD width="70.5938px"><FONT color="#00FF00">1’378</FONT></TD> <TD width="73.2812px">-188’000</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|0084001505</TD> <TD width="47.4688px">-</TD> <TD width="70.5938px"><FONT color="#FF0000">0</FONT></TD> <TD width="73.2812px">34’000</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|0086500010</TD> <TD width="47.4688px">-</TD> <TD width="70.5938px"><FONT color="#FF0000">0</FONT></TD> <TD width="73.2812px">3’000</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|0086531050</TD> <TD width="47.4688px">-</TD> <TD width="70.5938px"><FONT color="#FF0000">0</FONT></TD> <TD width="73.2812px">17’000</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|0086600010</TD> <TD width="47.4688px">-</TD> <TD width="70.5938px"><FONT color="#FF0000">0</FONT></TD> <TD width="73.2812px">11’000</TD> </TR> <TR> <TD width="119.516px">01.01.2024</TD> <TD width="192.438px">100|0370</TD> <TD width="122.188px">100|3722</TD> <TD width="171.078px">100|0300|0000009200</TD> <TD width="177.312px">100|B0000400002</TD> <TD width="47.4688px">-</TD> <TD width="70.5938px"><FONT color="#FF0000">0</FONT></TD> <TD width="73.2812px">66’000</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The goal is to bring the data like this:</P> <TABLE width="946"> <TBODY> <TR> <TD width="113">_KEY_Date_ID</TD> <TD width="155">_KEY_CompanyCode_ID</TD> <TD width="113">_KEY_Plant_ID</TD> <TD width="113">_KEY_ProfitCenter_ID</TD> <TD width="113">_KEY_CostElement_ID</TD> <TD width="113">Base Unit</TD> <TD width="113">Quantity</TD> <TD width="113">Betrag</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|0003100200</TD> <TD>M3</TD> <TD>1’378</TD> <TD>-188’000</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|0084001505</TD> <TD>-</TD> <TD><FONT color="#339966">1’378</FONT></TD> <TD>34’000</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|0086500010</TD> <TD>-</TD> <TD><FONT color="#339966">1’378</FONT></TD> <TD>3’000</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|0086531050</TD> <TD>-</TD> <TD><FONT color="#339966">1’378</FONT></TD> <TD>17’000</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|0086600010</TD> <TD>-</TD> <TD><FONT color="#339966">1’378</FONT></TD> <TD>11’000</TD> </TR> <TR> <TD>01.01.2024</TD> <TD>100|0370</TD> <TD>100|3722</TD> <TD>100|0300|0000009200</TD> <TD>100|B0000400002</TD> <TD>-</TD> <TD><FONT color="#339966">1’378</FONT></TD> <TD>66’000</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>If Base Unit = M3, take the Quantity and apply it to the other cost elements records by considering the Date, Company Code, Plant and Profit Center.</P> <P>I need a script solution .</P> <P>&nbsp;</P> <P>I hope someone can help me out here.</P> <P>&nbsp;</P> Mon, 11 Nov 2024 14:57:26 GMT https://community.qlik.com/t5/QlikView/Apply-value-to-next-record/m-p/2492089#M1226251 let12 2024-11-11T14:57:26Z Re: Apply value to next record https://community.qlik.com/t5/QlikView/Apply-value-to-next-record/m-p/2492096#M1226252 <P>Maybe in this way:</P> <P>m: mapping load distinct RelevantKey, Quantity from X where Quantity &gt; 0;</P> <P>t. load *, applymap('m',&nbsp;RelevantKey, '#NV') as QuantityNew from X,</P> Mon, 11 Nov 2024 15:21:40 GMT https://community.qlik.com/t5/QlikView/Apply-value-to-next-record/m-p/2492096#M1226252 marcus_sommer 2024-11-11T15:21:40Z