Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top 10 items

Hi,

How to display the top 10 items. in the bar chart.

Do we really need the rank function or we can show the values in descending order and restrict the visibility to 10.

can any one help me to display the top 10 item using rank function

regards,xxx.

Labels (1)
2 Replies
Not applicable
Author

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.

Regards

Not applicable
Author

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:

sum( {$<Product = {"=rank(sum(Sales),4,1) <= 10"}>} Sales )

Regards