https://community.qlik.com/t5/App-Development/Get-Value-of-the-upper-Ranking/m-p/2164540#M94586 <P>Hy Qlikers,</P> <P>I try to find a solution ( without script) to get the upper value in a list.</P> <P>In my exemple attached, i would like to calculate (in last column) the sales amount that is missinf to reach one rank.</P> <P>dylan &gt;&nbsp; 2 $ to reach 3rd place</P> <P>marc &gt; 5 $ to reach 2nd place</P> <P>jon &gt; 5 $ to reach the first place</P> <P>&nbsp;</P> <P>Thank you for your help <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> <P>&nbsp;</P> Tue, 23 Jan 2024 17:18:33 GMT maxime66 2024-01-23T17:18:33Z https://community.qlik.com/t5/App-Development/Get-Value-of-the-upper-Ranking/m-p/2164540#M94586 <P>Hy Qlikers,</P> <P>I try to find a solution ( without script) to get the upper value in a list.</P> <P>In my exemple attached, i would like to calculate (in last column) the sales amount that is missinf to reach one rank.</P> <P>dylan &gt;&nbsp; 2 $ to reach 3rd place</P> <P>marc &gt; 5 $ to reach 2nd place</P> <P>jon &gt; 5 $ to reach the first place</P> <P>&nbsp;</P> <P>Thank you for your help <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> <P>&nbsp;</P> Tue, 23 Jan 2024 17:18:33 GMT https://community.qlik.com/t5/App-Development/Get-Value-of-the-upper-Ranking/m-p/2164540#M94586 maxime66 2024-01-23T17:18:33Z