topic Re: bottom in QlikView

bottom

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

Iam using the below calculted dimesion to get top 5 clients

=if(aggr(rank(count(Key)),Client)<=5,Client)

How do i use this dimension to show bottom 5 clients

Thanks in advance

Re: bottom

jwjackso — Mon, 12 Mar 2018 10:20:05 GMT

Try if(aggr(rank(count(Key)),Client)<=5,(Client,(Numeric,Ascending)))

The sortable Aggr function is finally here!

Re: bottom

smilingjohn — Mon, 12 Mar 2018 10:22:32 GMT

Hi Jerry

this is not wotking

Re: bottom

tresB — Mon, 12 Mar 2018 10:27:29 GMT

May be just put minus before your measure count(), like: =if(aggr(rank(-count(Key)),Client)<=5,Client)

Re: bottom

smilingjohn — Mon, 12 Mar 2018 10:31:30 GMT

H tresseco

its not working.. i tired this one also

i want ti show a bar chart with bottom 5 clients

and one more bar chart with top 5 client

Re: bottom

tresB — Mon, 12 Mar 2018 10:48:09 GMT

Could you post a sample app and explain your expected output there?

Re: bottom

sergio0592 — Mon, 12 Mar 2018 10:55:32 GMT

So, try to create a variable V_max with :

=max(aggr(rank(count(Key)),Client))-5

And use it in your formula :

=if(aggr(rank(count(Key)),Client)>=V_max,Client)

Re: bottom

jwjackso — Mon, 12 Mar 2018 11:26:37 GMT

As an alternative, just display the Client in the dimension. For the first expression, use Rank(count(Key)) and hide that column on the presentation tab. On the "dimension limits" tab, restrict the values to the largest/smallest 5 and uncheck the "show others" option.

Re: bottom

akshaye_c_navale — Mon, 12 Mar 2018 12:30:25 GMT

Hey John,

Try below expression.

For Bottom 3

=IF(Aggr(Rank(-1*sum(Sales),1,1),(Region,(NUMERIC, ASCENDING)))<=3,Region)

For Top 3

=IF(Aggr(Rank(1*sum(Sales),1,1),(Region,(NUMERIC, ASCENDING)))<=3,Region) @

Re: bottom

Nagaraju_KCS — Mon, 12 Mar 2018 13:26:22 GMT

Try this,

=AGGR(IF(Rank(-Sum(Sales),4)<=5,Period),Period)