Hy Qlikers,
I try to find a solution ( without script) to get the upper value in a list.
In my exemple attached, i would like to calculate (in last column) the sales amount that is missinf to reach one rank.
dylan > 2 $ to reach 3rd place
marc > 5 $ to reach 2nd place
jon > 5 $ to reach the first place
Thank you for your help 😉