topic Re: Rank function: Top 10 but count greater than 1 in QlikView https://community.qlik.com/t5/QlikView/Rank-function-Top-10-but-count-greater-than-1/m-p/784466#M277669 <HTML><HEAD></HEAD><BODY><P>=aggr(if(Rank(If(count(if(Late='Y',Id))&gt;1,count(if(Late='Y',Id))))&lt;=10,DeskName),DeskName)</P><P></P><P>Select "Suppress When value is Null"</P></BODY></HTML> Wed, 25 Feb 2015 02:25:33 GMT anbu1984 2015-02-25T02:25:33Z Rank function: Top 10 but count greater than 1 https://community.qlik.com/t5/QlikView/Rank-function-Top-10-but-count-greater-than-1/m-p/784465#M277668 <HTML><HEAD></HEAD><BODY><P>Hi, I am using the below rank function in a chart dimension but want to exclude any DeskName where count(if(Late='Y'))=1, i.e. only include a top 10 of those with count greater than 1. How can I put this condition in the dimension field?</P><P></P><P><STRONG>=aggr(if(Rank(count(if(Late='Y',Id)))&lt;=10,DeskName),DeskName)</STRONG></P></BODY></HTML> Wed, 25 Feb 2015 01:47:34 GMT https://community.qlik.com/t5/QlikView/Rank-function-Top-10-but-count-greater-than-1/m-p/784465#M277668 sifatnabil 2015-02-25T01:47:34Z Re: Rank function: Top 10 but count greater than 1 https://community.qlik.com/t5/QlikView/Rank-function-Top-10-but-count-greater-than-1/m-p/784466#M277669 <HTML><HEAD></HEAD><BODY><P>=aggr(if(Rank(If(count(if(Late='Y',Id))&gt;1,count(if(Late='Y',Id))))&lt;=10,DeskName),DeskName)</P><P></P><P>Select "Suppress When value is Null"</P></BODY></HTML> Wed, 25 Feb 2015 02:25:33 GMT https://community.qlik.com/t5/QlikView/Rank-function-Top-10-but-count-greater-than-1/m-p/784466#M277669 anbu1984 2015-02-25T02:25:33Z