topic rank by frequency in QlikView https://community.qlik.com/t5/QlikView/rank-by-frequency/m-p/302447#M1198592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am fairly new to Qlikview.</P><P>I was wondering if there is a way to rank top ten items by frequency of them.</P><P>For example, in a multibox, after I select a few fields I want it to lists the frequency of each thing in the item field and show the top 10 near the top of the multibox.</P><P>Is there a way to do this?</P><P>Thanks for your help!</P></BODY></HTML> Fri, 28 Jan 2011 22:08:14 GMT 2011-01-28T22:08:14Z rank by frequency https://community.qlik.com/t5/QlikView/rank-by-frequency/m-p/302447#M1198592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am fairly new to Qlikview.</P><P>I was wondering if there is a way to rank top ten items by frequency of them.</P><P>For example, in a multibox, after I select a few fields I want it to lists the frequency of each thing in the item field and show the top 10 near the top of the multibox.</P><P>Is there a way to do this?</P><P>Thanks for your help!</P></BODY></HTML> Fri, 28 Jan 2011 22:08:14 GMT https://community.qlik.com/t5/QlikView/rank-by-frequency/m-p/302447#M1198592 2011-01-28T22:08:14Z rank by frequency https://community.qlik.com/t5/QlikView/rank-by-frequency/m-p/302448#M1198593 <HTML><HEAD></HEAD><BODY><P>Hi Sarina - the attached QVW may give you some ideas for sorting in a list/multi-box. If you're using QV10 the list box can display the frequency using the count() function. Let me know if this isn't what you're looking for.</P><P>-Isaiah</P></BODY></HTML> Fri, 28 Jan 2011 22:29:35 GMT https://community.qlik.com/t5/QlikView/rank-by-frequency/m-p/302448#M1198593 isaiah82 2011-01-28T22:29:35Z