topic Re: Top 20 in QlikView https://community.qlik.com/t5/QlikView/Top-20/m-p/1311520#M407643 <HTML><HEAD></HEAD><BODY><P>Top 20 details according to their count case</P></BODY></HTML> Mon, 22 May 2017 13:49:10 GMT master_student 2017-05-22T13:49:10Z Top 20 https://community.qlik.com/t5/QlikView/Top-20/m-p/1311518#M407641 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P>I need your helps as usual <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I have a table that contains a measure count (case) and field details, I wanna display the TOP 20 detail according to their count (case) and whene two details have the same count(case) display only the first :</P><P></P><P><IMG __jive_id="164289" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164289_Capture.PNG" style="height: auto;" /></P><P>the measure count (case)</P></BODY></HTML> Mon, 22 May 2017 13:45:14 GMT https://community.qlik.com/t5/QlikView/Top-20/m-p/1311518#M407641 master_student 2017-05-22T13:45:14Z Re: Top 20 https://community.qlik.com/t5/QlikView/Top-20/m-p/1311519#M407642 <HTML><HEAD></HEAD><BODY><P>You want over top 20 or top 20 per type cas?</P></BODY></HTML> Mon, 22 May 2017 13:48:33 GMT https://community.qlik.com/t5/QlikView/Top-20/m-p/1311519#M407642 sunny_talwar 2017-05-22T13:48:33Z Re: Top 20 https://community.qlik.com/t5/QlikView/Top-20/m-p/1311520#M407643 <HTML><HEAD></HEAD><BODY><P>Top 20 details according to their count case</P></BODY></HTML> Mon, 22 May 2017 13:49:10 GMT https://community.qlik.com/t5/QlikView/Top-20/m-p/1311520#M407643 master_student 2017-05-22T13:49:10Z Re: Top 20 https://community.qlik.com/t5/QlikView/Top-20/m-p/1311521#M407644 <HTML><HEAD></HEAD><BODY><P><EM>add the calculated dimension for details like below</EM></P><P><EM style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">if(aggr(rank(count(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">case</SPAN>)),Detail,Type cas)&lt;=20,<EM style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Detail</EM>) </EM></P></BODY></HTML> Mon, 22 May 2017 13:51:08 GMT https://community.qlik.com/t5/QlikView/Top-20/m-p/1311521#M407644 avinashelite 2017-05-22T13:51:08Z Re: Top 20 https://community.qlik.com/t5/QlikView/Top-20/m-p/1311522#M407645 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>=If(Num(Num#(Rank(Count(Case), 0, 2))) &lt; 21, <SPAN style="font-size: 13.3333px;">Count</SPAN>(Case))</STRONG></P></BODY></HTML> Mon, 22 May 2017 13:52:10 GMT https://community.qlik.com/t5/QlikView/Top-20/m-p/1311522#M407645 sunny_talwar 2017-05-22T13:52:10Z