https://community.qlik.com/t5/QlikView/How-to-sum-4-greatest-values-per-row/m-p/1554514#M744414 Can you share some more data with example output you are looking for? Sat, 09 Mar 2019 04:24:23 GMT vishsaggi 2019-03-09T04:24:23Z https://community.qlik.com/t5/QlikView/How-to-sum-4-greatest-values-per-row/m-p/1554498#M744413 <P>I need to sum the best three weeks per participant of an event I am running.&nbsp; Essentially people need to compete in at least 4 weeks but they could compete in as many as 6.&nbsp; Its been a while since I have used Qlik and am a bit rusty <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;&nbsp;</P><P>Logically it would look something like this</P><P>&nbsp;</P><P>If the count of weeks is greater than 4 then sum the greatest 4 values per player.</P><P>Data is as follows</P><P>Player name&nbsp; &nbsp; Week&nbsp; &nbsp;Score</P><P>Player 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50</P><P>Player 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 52</P><P>Player 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45</P><P>Player 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60</P><P>etc....</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sum-4-greatest-values-per-row/m-p/1554498#M744413 JKoczeniak 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-to-sum-4-greatest-values-per-row/m-p/1554514#M744414 Can you share some more data with example output you are looking for? Sat, 09 Mar 2019 04:24:23 GMT https://community.qlik.com/t5/QlikView/How-to-sum-4-greatest-values-per-row/m-p/1554514#M744414 vishsaggi 2019-03-09T04:24:23Z