https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116238#M91085 <P>Thank you, this worked perfect!</P> Tue, 12 Sep 2023 21:42:44 GMT JeffMelon 2023-09-12T21:42:44Z https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116219#M91083 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeffMelon_0-1694547468987.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116159i8E0C5E3E182DDDFF/image-size/medium?v=v2&amp;px=400" role="button" title="JeffMelon_0-1694547468987.png" alt="JeffMelon_0-1694547468987.png" /></span></P> <P>&nbsp;</P> <P>I am trying to sum Loads by the unique instances of each Lane ID, I tried using sum distinct but that gave me 28, not 31.</P> <P>Not sure if I should be using set analysis for this, can someone share their thoughts on this?</P> <P>&nbsp;</P> <P>Thank you</P> Tue, 12 Sep 2023 19:43:01 GMT https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116219#M91083 JeffMelon 2023-09-12T19:43:01Z https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116234#M91084 <P>Hi, try this.</P> <P>=Sum(Aggr(Only(Loads), Lane, [Lane ID], Loads))</P> Tue, 12 Sep 2023 21:09:35 GMT https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116234#M91084 BrunPierre 2023-09-12T21:09:35Z https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116238#M91085 <P>Thank you, this worked perfect!</P> Tue, 12 Sep 2023 21:42:44 GMT https://community.qlik.com/t5/App-Development/Sum-values-in-a-field-by-unique-instance-of-another-field/m-p/2116238#M91085 JeffMelon 2023-09-12T21:42:44Z