topic Re: display N top value in straight table in QlikView https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381534#M571672 <HTML><HEAD></HEAD><BODY><P>In QV 11&nbsp; you can use dimension limits.</P><P></P><P>You can use expression or variable.</P></BODY></HTML> Tue, 28 Aug 2012 13:55:51 GMT whiteline 2012-08-28T13:55:51Z display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381532#M571670 <HTML><HEAD></HEAD><BODY><P>I looking for a best idea to show more than 100 top values in straight chart (maybe slider or an input field with variable)</P><P></P><P></P><P>check posted sample file ....</P></BODY></HTML> Tue, 28 Aug 2012 12:06:46 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381532#M571670 2012-08-28T12:06:46Z Re: display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381533#M571671 <HTML><HEAD></HEAD><BODY><P>....or a quick macro exporting first N rows from this chart to excell....</P></BODY></HTML> Tue, 28 Aug 2012 12:51:28 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381533#M571671 2012-08-28T12:51:28Z Re: display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381534#M571672 <HTML><HEAD></HEAD><BODY><P>In QV 11&nbsp; you can use dimension limits.</P><P></P><P>You can use expression or variable.</P></BODY></HTML> Tue, 28 Aug 2012 13:55:51 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381534#M571672 whiteline 2012-08-28T13:55:51Z Re: display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381535#M571673 <HTML><HEAD></HEAD><BODY><P>i've got QV10 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 28 Aug 2012 14:06:55 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381535#M571673 2012-08-28T14:06:55Z Re: display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381536#M571674 <HTML><HEAD></HEAD><BODY><P>Use this as your dimension</P><P></P><P>=aggr(if(rank(sum([SPR CSN]))&lt;=100,Nazwa),Nazwa)</P></BODY></HTML> Tue, 28 Aug 2012 14:16:06 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381536#M571674 2012-08-28T14:16:06Z Re: display N top value in straight table https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381537#M571675 <HTML><HEAD></HEAD><BODY><P>perfetto mi amigo:P</P></BODY></HTML> Tue, 28 Aug 2012 15:33:25 GMT https://community.qlik.com/t5/QlikView/display-N-top-value-in-straight-table/m-p/381537#M571675 2012-08-28T15:33:25Z