topic Re: Set analysis.. in QlikView

Set analysis..

prabhas277 — Mon, 16 Feb 2015 08:38:17 GMT

Hi To all,

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

Re: Set analysis..

prma7799 — Mon, 16 Feb 2015 08:47:24 GMT

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

Re: Set analysis..

Gysbert_Wassenaar — Mon, 16 Feb 2015 08:48:39 GMT

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)

Re: Set analysis..

ashfaq_haseeb — Mon, 16 Feb 2015 09:15:01 GMT

Hi, Check the attached application Regards ASHFAQ