https://community.qlik.com/t5/App-Development/Roll-up-for-BoM-in-straight-table/m-p/1865074#M71402 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;Any&nbsp;suggestion ? Some of your posts goes in this direction</P> Tue, 30 Nov 2021 17:56:01 GMT William2 2021-11-30T17:56:01Z https://community.qlik.com/t5/App-Development/Roll-up-for-BoM-in-straight-table/m-p/1864387#M71349 <P>Hello Community,&nbsp;</P> <P>I try to make a sum/multiplication Roll up for Quantities (numeric) over a with hierarchy created Path.&nbsp;</P> <P>my table looks like&nbsp;</P> <P>Path&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Quantities&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;What I want to achive(TotalQuantites)</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P> <P>A;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; ( 1*2)</P> <P>A;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; ( 1*5)</P> <P>A;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 (1*1)</P> <P>A;B;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 ( 1*2*3)</P> <P>A;B;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 (1*2*5)</P> <P>And so on with far more complex lists.&nbsp;&nbsp;</P> <P>I have already created the&nbsp;TotalQuantites field in script. But duo to new&nbsp;<SPAN class="Y2IQFc">requirements I need to calculate it in UI.&nbsp;</SPAN></P> <P>Maybe something like "if(left(Path, len(Path)-2) = above(Path),&nbsp; &nbsp; RangeSum(Above(sum(Quantities)),0,rowno()))"</P> <P>I guess I need a combination of RangeSum, above, wildmatch to compare current line Path with above(?) matching Path.</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6622">@hic</a>&nbsp;</P> <P>got some nice explanation to handle BoM and create a TotalQty field in script but not in UI.&nbsp;</P> <P>Maybe you guys have some nice input for me.&nbsp;</P> <P>&nbsp;</P> <P>Thank you !</P> <P>&nbsp;</P> Wed, 22 Dec 2021 20:40:09 GMT https://community.qlik.com/t5/App-Development/Roll-up-for-BoM-in-straight-table/m-p/1864387#M71349 William2 2021-12-22T20:40:09Z https://community.qlik.com/t5/App-Development/Roll-up-for-BoM-in-straight-table/m-p/1865074#M71402 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;Any&nbsp;suggestion ? Some of your posts goes in this direction</P> Tue, 30 Nov 2021 17:56:01 GMT https://community.qlik.com/t5/App-Development/Roll-up-for-BoM-in-straight-table/m-p/1865074#M71402 William2 2021-11-30T17:56:01Z