topic Dynamic dimension Top X in QlikView

Dynamic dimension Top X

Mon, 02 May 2011 20:57:16 GMT

Hi Community,

I have errors and related error types. I'm trying to show the error types of the top 5 errors in 5 bar charts.
Therefore I'm trying to do a dynamic dimension.

=if(aggr(rank(sum(Amount)), Error) = 1 , Type ) for all error types where error is rank 1

=if(aggr(rank(sum(Amount)), Error) = 2 , Type ) for all error types where error is rank 2

and so on.

But in this case I get only the top 1 error type. Can someone please help me with this forumla

thanks!!!

Re: Dynamic dimension Top X

Anonymous — Sun, 14 Sep 2014 10:40:37 GMT

Hi,

take a look to the app aatached

Re: Dynamic dimension Top X

ashfaq_haseeb — Sun, 14 Sep 2014 11:26:01 GMT

Check This,

Regards

ASHFAQ

Re: Dynamic dimension Top X

Sun, 14 Sep 2014 12:12:08 GMT

Try like this In expression --> Sum(Amount)

In Dimension limit

Instead of variable you can also use constant numbers