topic Re: Finding Bottom x Clients in QlikView

Finding Bottom x Clients

johngouws — Wed, 12 Nov 2014 12:38:10 GMT

Good afternoon,

I wonder if someone has the solution to my problem?

I am able to establish the top x Clients by their sales amounts, but I am having an issue with identifying to bottom x Clients.

Looking at the attached example, the slider identifies the number of Clients to show.

I believe where I am going wrong is that I first need to establish the bottom ranking, then work backwards, if that makes sense!

In the solution, when selecting top 4, I should be returning Clients L to O as the bottom 4.

Thank you in advance for your help.

Regards.

ashfaq_haseeb — Wed, 12 Nov 2014 12:45:08 GMT

May be like this

Regards

ASHFAQ

jpenuliar — Wed, 12 Nov 2014 12:45:35 GMT

Hi try the below:

"-sum"

=if(aggr(rank(-sum(Amount)),Client)<=v_top,

aggr(rank(sum(Amount)),Client),null())

johngouws — Wed, 12 Nov 2014 12:58:41 GMT

Thank you Jonathan and Ashfaq for the answers.

A minus sign - really!!

Jonathan, unfortunately I have to give it to Ashfaq as he was slightly faster on the button!!

I really do appreciate the quick answers.

Regards - John

jpenuliar — Wed, 12 Nov 2014 13:00:04 GMT

lol