topic Sum the XX best values in QlikView https://community.qlik.com/t5/QlikView/Sum-the-XX-best-values/m-p/237843#M88830 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm seeking for a solution to sum the xx best values from my field.</P><P>If I have 9, 8, 7, 6, 5, 4, 3, 2, 1 and i want the sum of the 5 best values, it will be 9+8+7+6+5 = 35</P><P>The difficulty is that if I have 9, 8, <B>8</B>, 7, 6, 5, 4, 3, 2, 1 and i always want the sum of the 5 best values, it will be 9+8+8+7+6 = 38</P><P>Many thanks for the person who will help me ! [;)]</P></BODY></HTML> Thu, 29 Jul 2010 16:21:17 GMT 2010-07-29T16:21:17Z Sum the XX best values https://community.qlik.com/t5/QlikView/Sum-the-XX-best-values/m-p/237843#M88830 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm seeking for a solution to sum the xx best values from my field.</P><P>If I have 9, 8, 7, 6, 5, 4, 3, 2, 1 and i want the sum of the 5 best values, it will be 9+8+7+6+5 = 35</P><P>The difficulty is that if I have 9, 8, <B>8</B>, 7, 6, 5, 4, 3, 2, 1 and i always want the sum of the 5 best values, it will be 9+8+8+7+6 = 38</P><P>Many thanks for the person who will help me ! [;)]</P></BODY></HTML> Thu, 29 Jul 2010 16:21:17 GMT https://community.qlik.com/t5/QlikView/Sum-the-XX-best-values/m-p/237843#M88830 2010-07-29T16:21:17Z