topic List Box in QlikView https://community.qlik.com/t5/QlikView/List-Box/m-p/425288#M158404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can we set top 5 values in list box?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 05 Apr 2013 07:45:50 GMT 2013-04-05T07:45:50Z List Box https://community.qlik.com/t5/QlikView/List-Box/m-p/425288#M158404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can we set top 5 values in list box?</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 05 Apr 2013 07:45:50 GMT https://community.qlik.com/t5/QlikView/List-Box/m-p/425288#M158404 2013-04-05T07:45:50Z Re: List Box https://community.qlik.com/t5/QlikView/List-Box/m-p/425289#M158405 <HTML><HEAD></HEAD><BODY><P>Use an expression in your list box (select &lt;Expression&gt; from the field list drop down in general tab of list box properties), something like</P><P></P><P>=aggr(if(rank(sum(SALES)&lt;=5, SALESREP), SALESREP)</P></BODY></HTML> Fri, 05 Apr 2013 07:49:41 GMT https://community.qlik.com/t5/QlikView/List-Box/m-p/425289#M158405 swuehl 2013-04-05T07:49:41Z Re: List Box https://community.qlik.com/t5/QlikView/List-Box/m-p/425290#M158406 <HTML><HEAD></HEAD><BODY><P>Hi in expression,</P><P> To get Top 5 customers in revenue wise.</P><P></P><P>=aggr(if(rank(sum(Revenue))&lt;=5 Customer),Customer)</P><P></P><P></P><P>I hope it will help u.</P><P></P><P></P><P>I</P></BODY></HTML> Fri, 05 Apr 2013 07:54:28 GMT https://community.qlik.com/t5/QlikView/List-Box/m-p/425290#M158406 khadeer 2013-04-05T07:54:28Z