topic Re: Listbox in QlikView https://community.qlik.com/t5/QlikView/Listbox/m-p/587946#M218019 <HTML><HEAD></HEAD><BODY><P>Please close the thread by selection appropriate answer..</P><P>Thanks...</P><P></P><P>UPDATE : Please close this thread..</P></BODY></HTML> Tue, 18 Mar 2014 09:54:26 GMT MK_QSL 2014-03-18T09:54:26Z Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/587942#M218015 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have list box i want see 1000 records&nbsp; after reload the QVW. but don't use in script in first 1000.</P><P></P><P>How can i do ...........</P><P></P><P>Thanks&amp;Regards:</P><P>Dolly</P></BODY></HTML> Tue, 18 Mar 2014 09:37:12 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/587942#M218015 dolly777 2014-03-18T09:37:12Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/587943#M218016 <HTML><HEAD></HEAD><BODY><P>Something Like below to write in List Box Expression...</P><P></P><P>=IF(Aggr(RANK(SUM(Sales)),[Customer Name])&lt;=1000,[Customer Name])</P></BODY></HTML> Tue, 18 Mar 2014 09:42:53 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/587943#M218016 MK_QSL 2014-03-18T09:42:53Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/587944#M218017 <HTML><HEAD></HEAD><BODY><P>You can use RANK function as follows:</P><P></P><P>=if(aggr(rank(AMOUNT),AMOUNT) &lt;=1000 ,AMOUNT)</P><P></P><P>THanks,</P><P>Angad</P></BODY></HTML> Tue, 18 Mar 2014 09:47:26 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/587944#M218017 2014-03-18T09:47:26Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/587945#M218018 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>It's working fine Thank u so much.</P></BODY></HTML> Tue, 18 Mar 2014 09:52:19 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/587945#M218018 dolly777 2014-03-18T09:52:19Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/587946#M218019 <HTML><HEAD></HEAD><BODY><P>Please close the thread by selection appropriate answer..</P><P>Thanks...</P><P></P><P>UPDATE : Please close this thread..</P></BODY></HTML> Tue, 18 Mar 2014 09:54:26 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/587946#M218019 MK_QSL 2014-03-18T09:54:26Z