topic Re: top 10 records minimum in QlikView https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386972#M813465 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><A href="https://community.qlikview.com/thread/62973" title="https://community.qlikview.com/thread/62973">https://community.qlikview.com/thread/62973</A></P><P></P><P><A href="https://community.qlik.com/thread/151541">Remove the last row / Max Row</A></P></BODY></HTML> Thu, 21 Sep 2017 05:02:52 GMT prma7799 2017-09-21T05:02:52Z top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386969#M813462 <HTML><HEAD></HEAD><BODY><P><SPAN style="vertical-align: inherit;">Hola .</SPAN></P><P><SPAN style="vertical-align: inherit;">Quiero mostrar en una tabla sencilla con sólo 10 registros pero en mi mesa que muestra los 12 registros.</SPAN></P><P><SPAN style="vertical-align: inherit;">¿Cómo borro las últimas 2 vueltas?</SPAN></P><P><SPAN style="vertical-align: inherit;">tener en cuenta que los primeros 10 registros tienen que ser los mismos y los valores son de menor a mayor.</SPAN></P><P><IMG __jive_id="177235" alt="qlik1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177235_qlik1.PNG" style="height: auto;" /></P><P></P><P><SPAN style="vertical-align: inherit;">más o menos tiene que mostrarme como esto</SPAN></P><P><IMG __jive_id="177245" alt="qlik2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/177245_qlik2.PNG" style="height: auto;" /></P><P><SPAN style="vertical-align: inherit;">Por favor me ayude con este tema.</SPAN></P><P><SPAN style="vertical-align: inherit;">Saludos</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386969#M813462 cristianj23a 2020-11-25T16:16:04Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386970#M813463 <HTML><HEAD></HEAD><BODY><P>Could you share your sample qvw or let know what expression/limit you have used that gives you these 12 values? For getting lowest values you can use negative ranking like: <STRONG>=Rank( -Sum(Sales))&lt;=10</STRONG></P></BODY></HTML> Thu, 21 Sep 2017 04:56:02 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386970#M813463 tresB 2017-09-21T04:56:02Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386971#M813464 <HTML><HEAD></HEAD><BODY><P>Ready already I shared the qvw.</P><P>The code is little more complicated.</P></BODY></HTML> Thu, 21 Sep 2017 05:00:58 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386971#M813464 cristianj23a 2017-09-21T05:00:58Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386972#M813465 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><A href="https://community.qlikview.com/thread/62973" title="https://community.qlikview.com/thread/62973">https://community.qlikview.com/thread/62973</A></P><P></P><P><A href="https://community.qlik.com/thread/151541">Remove the last row / Max Row</A></P></BODY></HTML> Thu, 21 Sep 2017 05:02:52 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386972#M813465 prma7799 2017-09-21T05:02:52Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386973#M813466 <HTML><HEAD></HEAD><BODY><P>Hi Cristian,</P><P>You can do it in two ways.</P><P>1. You can limit the dimensions</P><P>2. You can use the rank () in your expression</P><P><A href="https://community.qlik.com/thread/61030">Rank function in expression</A></P><P><A href="http://qlik4life.com/2015/12/04/rank-in-the-qlikview/" title="http://qlik4life.com/2015/12/04/rank-in-the-qlikview/">Rank in the Qlikview - Qlikview for Life (Qlik4life)</A></P><P><A href="https://community.qlik.com/thread/159148">How to use rank function?</A></P><P></P><P>Rgds,</P><P>Tharindu</P></BODY></HTML> Thu, 21 Sep 2017 05:03:40 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386973#M813466 dinuwanbr 2017-09-21T05:03:40Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386974#M813467 <HTML><HEAD></HEAD><BODY><P>Could you share with the right expression? I don't see the same view you shared, in the qvw shared.</P></BODY></HTML> Thu, 21 Sep 2017 05:10:34 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386974#M813467 tresB 2017-09-21T05:10:34Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386975#M813468 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I entered the links but it is not what I am looking for.</P></BODY></HTML> Thu, 21 Sep 2017 05:13:25 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386975#M813468 cristianj23a 2017-09-21T05:13:25Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386976#M813469 <HTML><HEAD></HEAD><BODY><P>Hi Tharindu.</P><P>I found the solution, it was simpler than I thought.</P><P></P><P><IMG alt="qlik2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177496_qlik2.PNG" style="height: 405px; width: 620px;" /></P><P></P><P>In properties / presentation select the maximum of records. In this case i entered 10 records.</P><P>Same thanks for the help.</P><P>Greetings.</P></BODY></HTML> Fri, 22 Sep 2017 17:16:44 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1386976#M813469 cristianj23a 2017-09-22T17:16:44Z Re: top 10 records minimum https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1569633#M813470 <P>Hi! Could you explain step by step the process to do the selection of the 10 values?</P><P>Thanks so much</P> Mon, 15 Apr 2019 19:45:11 GMT https://community.qlik.com/t5/QlikView/top-10-records-minimum/m-p/1569633#M813470 SANIGEST1 2019-04-15T19:45:11Z