topic top 10 items in QlikView https://community.qlik.com/t5/QlikView/top-10-items/m-p/225834#M78099 <HTML><HEAD></HEAD><BODY><P>Hi there, yes indeed, you dont need rank function to accomplish this task, as you pointed correctly you can oder in descending mode and set the "max visible number" option to 10 in the chart properties tab. Also make sure, the "Show X-Axis scrollbar" option under the same tab is unchecked.</P><P></P><P>Regards</P></BODY></HTML> Fri, 01 Oct 2010 17:07:58 GMT 2010-10-01T17:07:58Z top 10 items https://community.qlik.com/t5/QlikView/top-10-items/m-p/225833#M78098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to display the top 10 items. in the bar chart.</P><P>Do we really need the rank function or we can show the values in descending order and restrict the visibility to 10.</P><P>can any one help me to display the top 10 item using rank function</P><P></P><P>regards,xxx.</P><P></P><P></P></BODY></HTML> Fri, 01 Oct 2010 16:55:31 GMT https://community.qlik.com/t5/QlikView/top-10-items/m-p/225833#M78098 2010-10-01T16:55:31Z top 10 items https://community.qlik.com/t5/QlikView/top-10-items/m-p/225834#M78099 <HTML><HEAD></HEAD><BODY><P>Hi there, yes indeed, you dont need rank function to accomplish this task, as you pointed correctly you can oder in descending mode and set the "max visible number" option to 10 in the chart properties tab. Also make sure, the "Show X-Axis scrollbar" option under the same tab is unchecked.</P><P></P><P>Regards</P></BODY></HTML> Fri, 01 Oct 2010 17:07:58 GMT https://community.qlik.com/t5/QlikView/top-10-items/m-p/225834#M78099 2010-10-01T17:07:58Z top 10 items https://community.qlik.com/t5/QlikView/top-10-items/m-p/225835#M78100 <HTML><HEAD></HEAD><BODY><P>Sorry, I think I misunderstood your question, I only read the first part. You can limit the number of objects display with rank function. For example if you want to display the top 10 selling products, add Product as a dimension and wirte a expression similar to the following:</P><P>sum( {$&lt;Product = {"=rank(sum(Sales),4,1) &lt;= 10"}&gt;} Sales )</P><P>Regards</P></BODY></HTML> Fri, 01 Oct 2010 17:13:27 GMT https://community.qlik.com/t5/QlikView/top-10-items/m-p/225835#M78100 2010-10-01T17:13:27Z