topic Re: top 10 in QlikView https://community.qlik.com/t5/QlikView/top-10/m-p/72020#M11886 <HTML><HEAD></HEAD><BODY><P>Can you attach sample dataset ?</P></BODY></HTML> Thu, 08 Feb 2018 10:47:17 GMT YoussefBelloum 2018-02-08T10:47:17Z top 10 https://community.qlik.com/t5/QlikView/top-10/m-p/72016#M11882 <HTML><HEAD></HEAD><BODY><P>Guys Hello,</P><P></P><P> i want to get the <STRONG style="font-size: 12pt;">top 10</STRONG> of my rows based on the field sla inter</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192801_Capture.PNG" style="height: 163px; width: 620px;" /></P><P>I did that :</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/192802_Capture.PNG" style="height: 309px; width: 620px;" /></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/192803_Capture.PNG" style="height: 341px; width: 620px;" /></P><P>but i still get all the rows</P><P></P><P>any idea please</P></BODY></HTML> Thu, 08 Feb 2018 10:12:45 GMT https://community.qlik.com/t5/QlikView/top-10/m-p/72016#M11882 master_student 2018-02-08T10:12:45Z Re: top 10 https://community.qlik.com/t5/QlikView/top-10/m-p/72017#M11883 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can do this on your expression (remove the customized sorting):</P><P></P><P><STRONG>=if(rank(sum(SLA_INTERM),4)&lt;=10, <SPAN style="font-size: 10pt;">your_expression)</SPAN></STRONG></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">like this you will have your TOP 10 expression value depending on the SLA_INTERM</SPAN></P></BODY></HTML> Thu, 08 Feb 2018 10:19:49 GMT https://community.qlik.com/t5/QlikView/top-10/m-p/72017#M11883 YoussefBelloum 2018-02-08T10:19:49Z Re: top 10 https://community.qlik.com/t5/QlikView/top-10/m-p/72018#M11884 <HTML><HEAD></HEAD><BODY><P>try to use the Limit on presentation tab</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192807_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 08 Feb 2018 10:21:29 GMT https://community.qlik.com/t5/QlikView/top-10/m-p/72018#M11884 zhadrakas 2018-02-08T10:21:29Z Re: top 10 https://community.qlik.com/t5/QlikView/top-10/m-p/72019#M11885 <HTML><HEAD></HEAD><BODY><P>Thanks but both solutions didn't work</P></BODY></HTML> Thu, 08 Feb 2018 10:40:45 GMT https://community.qlik.com/t5/QlikView/top-10/m-p/72019#M11885 master_student 2018-02-08T10:40:45Z Re: top 10 https://community.qlik.com/t5/QlikView/top-10/m-p/72020#M11886 <HTML><HEAD></HEAD><BODY><P>Can you attach sample dataset ?</P></BODY></HTML> Thu, 08 Feb 2018 10:47:17 GMT https://community.qlik.com/t5/QlikView/top-10/m-p/72020#M11886 YoussefBelloum 2018-02-08T10:47:17Z