topic Rank min and max values in QlikView https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361959#M575825 <HTML><HEAD></HEAD><BODY><P>Try to rank for -sum([SSTT kg]):</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">IF(AGGR(RANK(-</SPAN><STRONG style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><EM>SUM([SSTT kg]</EM></STRONG><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">)), [SSTT kg]) &lt;= $(Nmin), [SSTT kg])</SPAN></P></BODY></HTML> Fri, 20 Apr 2012 19:26:19 GMT swuehl 2012-04-20T19:26:19Z Rank min and max values https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361958#M575824 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to do a ranking of the top X and the less top Y, you know? The X max values and the Y min values of a chart.</P><P></P><P>IF(AGGR(RANK(SUM([SSTT kg])), [SSTT kg]) &lt;= $(Nmax), [SSTT kg], </P><P>IF(AGGR(RANK(<STRONG><EM>SUM([SSTT kg]</EM></STRONG>)), [SSTT kg]) &lt;= $(Nmin), [SSTT kg]))</P><P></P><P>I need to change the second IF to get a number of minimum values</P><P></P><P>Any help would be appreciated.</P><P></P><P>Regardas, </P><P>Chema</P></BODY></HTML> Fri, 20 Apr 2012 19:17:26 GMT https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361958#M575824 chematos 2012-04-20T19:17:26Z Rank min and max values https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361959#M575825 <HTML><HEAD></HEAD><BODY><P>Try to rank for -sum([SSTT kg]):</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">IF(AGGR(RANK(-</SPAN><STRONG style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><EM>SUM([SSTT kg]</EM></STRONG><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">)), [SSTT kg]) &lt;= $(Nmin), [SSTT kg])</SPAN></P></BODY></HTML> Fri, 20 Apr 2012 19:26:19 GMT https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361959#M575825 swuehl 2012-04-20T19:26:19Z Rank min and max values https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361960#M575826 <HTML><HEAD></HEAD><BODY><P>I had thought something like that but I haven´t faith in a solution so easy.... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P><P></P><P>Thank you swehl !!!</P></BODY></HTML> Fri, 20 Apr 2012 19:32:14 GMT https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/361960#M575826 chematos 2012-04-20T19:32:14Z Re: Rank min and max values https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/1769032#M575827 Wed, 16 Dec 2020 16:05:32 GMT https://community.qlik.com/t5/QlikView/Rank-min-and-max-values/m-p/1769032#M575827 Srinivas 2020-12-16T16:05:32Z