topic Re: Group by keys in App Development

topic Re: Group by keys in App Development https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1970706#M80085 <P>=ONLY(AGGR(MIN(WeightedAverage),Key1))</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_1-1660910349801.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87080i9E649FFEB79A622B/image-size/medium?v=v2&px=400" role="button" title="peter_brown_1-1660910349801.png" alt="peter_brown_1-1660910349801.png" /></span></P> <P> </P> <P> </P> <P> </P> <P> </P> Fri, 19 Aug 2022 11:59:28 GMT BrunPierre 2022-08-19T11:59:28Z Group by keys https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1970330#M80061 <TABLE width="883"> <TBODY> <TR> <TD width="97">Key</TD> <TD width="103">EAP Number</TD> <TD width="129">Description</TD> <TD width="84">Flag</TD> <TD width="133">CDM_Unit_Price</TD> <TD width="101">Key1</TD> <TD width="172">WeightedAverage</TD> <TD width="64">CPT Code</TD> </TR> <TR> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD>48.815326373101</TD> <TD> </TD> </TR> <TR> <TD>RC112</TD> <TD>112</TD> <TD>AV</TD> <TD>RC</TD> <TD>217</TD> <TD>RC|96372</TD> <TD>0.064323455088445</TD> <TD>96372</TD> </TR> <TR> <TD>ROPH112</TD> <TD>112</TD> <TD>AB</TD> <TD>CA</TD> <TD>124</TD> <TD>ROPH96372</TD> <TD>17.043596508616</TD> <TD>96372</TD> </TR> <TR> <TD>RUH112</TD> <TD>112</TD> <TD>CD</TD> <TD>CA</TD> <TD>123.94</TD> <TD>RUH96372</TD> <TD>36.381438588074</TD> <TD>96372</TD> </TR> <TR> <TD>RC23</TD> <TD>23</TD> <TD>BG</TD> <TD>RC</TD> <TD>217</TD> <TD>RC|96372</TD> <TD>48.333502366464</TD> <TD>96372</TD> </TR> <TR> <TD>ROPH23</TD> <TD>23</TD> <TD>BH</TD> <TD>CA</TD> <TD>124</TD> <TD>ROPH96372</TD> <TD>22.828434560022</TD> <TD>96372</TD> </TR> <TR> <TD>RUH23</TD> <TD>23</TD> <TD>GH</TD> <TD>CA</TD> <TD>123.94</TD> <TD>RUH96372</TD> <TD>50.019778552919</TD> <TD>96372</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Here we have calculated weighted Average based on Key.</P> <P>then again we have to show the weigted average grouped by Key1</P> <P>output should be like: Only a single row item based on Key1.</P> <P>how to do please suggest.</P> <TABLE width="883"> <TBODY> <TR> <TD width="97">Key</TD> <TD width="103">EAP Number</TD> <TD width="129">Description</TD> <TD width="84">Flag</TD> <TD width="133">CDM_Unit_Price</TD> <TD width="101">Key1</TD> <TD width="172">WeightedAverage</TD> <TD width="64">CPT Code</TD> </TR> <TR> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD>48.815326373101</TD> <TD> </TD> </TR> <TR> <TD>RC112</TD> <TD>112</TD> <TD>AV</TD> <TD>RC</TD> <TD>217</TD> <TD>RC|96372</TD> <TD>0.064323455088445</TD> <TD>96372</TD> </TR> <TR> <TD>ROPH112</TD> <TD>112</TD> <TD>AB</TD> <TD>CA</TD> <TD>124</TD> <TD>ROPH96372</TD> <TD>17.043596508616</TD> <TD>96372</TD> </TR> <TR> <TD>RUH112</TD> <TD>112</TD> <TD>CD</TD> <TD>CA</TD> <TD>123.94</TD> <TD>RUH96372</TD> <TD>36.381438588074</TD> <TD>96372</TD> </TR> <TR> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> Thu, 18 Aug 2022 14:40:59 GMT https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1970330#M80061 agarwal16 2022-08-18T14:40:59Z Re: Group by keys https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1970706#M80085 <P>=ONLY(AGGR(MIN(WeightedAverage),Key1))</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_1-1660910349801.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87080i9E649FFEB79A622B/image-size/medium?v=v2&px=400" role="button" title="peter_brown_1-1660910349801.png" alt="peter_brown_1-1660910349801.png" /></span></P> <P> </P> <P> </P> <P> </P> <P> </P> Fri, 19 Aug 2022 11:59:28 GMT https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1970706#M80085 BrunPierre 2022-08-19T11:59:28Z Re: Group by keys https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1973083#M80284 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/192034">@agarwal16</a> <SPAN>Did it solve your problem? please mark accordingly.<BR /></SPAN></P> Thu, 25 Aug 2022 13:58:06 GMT https://community.qlik.com/t5/App-Development/Group-by-keys/m-p/1973083#M80284 BrunPierre 2022-08-25T13:58:06Z