Set analysis..

[prabhas277]

Hi To all,

I want top 5 records with out using the dimension limits..how? and share the experssion?

[prma7799]

Hi Prabhas,

There are 2 ways you can achieve these results:

1. You can use Rank() function in the expressions.

2. You can use "Dimension limits" & set some smallest, largest or first values to be shown. to access Dimesion limits tab, you need to go to the properties of the chart & there you will a tab as "Dimension Limits" .

http://community.qlik.com/thread/92561

Thanks

Prashant

[Gysbert_Wassenaar]

If you want the top 5 customers based on the sum of sales it would be something like

=sum({<customer={'=$(rank(sum(sales))<=5)'}>}sales)

[ashfaq_haseeb]

Hi, Check the attached application Regards ASHFAQ