topic Re: Choosing Bottom 5 in QlikView

Choosing Bottom 5

Mon, 15 Jun 2015 14:38:58 GMT

Hi Experts

In my Qvw i am using the dimension Limits to Show top 10 customers for each branch

but now I want only the Bottom 5 in my top ten list of Customers for each branch

Bottom 5 in that Top 10

How can i do that

Please Suggest

Re: Choosing Bottom 5

ramoncova06 — Mon, 15 Jun 2015 14:53:41 GMT

the attached example should work

Re: Choosing Bottom 5

Mon, 15 Jun 2015 15:11:33 GMT

HI Ramon

I already tried this method, and its not working

Is it possible to do the restriction on Sort Tab

Re: Choosing Bottom 5

Mon, 15 Jun 2015 15:35:58 GMT

Any other Suggestions Please

Re: Choosing Bottom 5

ramoncova06 — Mon, 15 Jun 2015 15:50:11 GMT

not that remember

this should get it done for you

*** Edited since I missed to upload the correct version

Re: Choosing Bottom 5

Mon, 15 Jun 2015 17:05:55 GMT

Hi Ramon

Actually in my data there are 152 branches

How to implement this

and my Expression Calculation is with MTD for Sales

Re: Choosing Bottom 5

ramoncova06 — Mon, 15 Jun 2015 18:35:15 GMT

I was hoping your branches where a smaller number, since I normally try to avoid calculated dimensions and if, but since it seems as we do not have another option try with this

=if(aggr(num(rank(sum(sum_val), 4)), Branch,Rank) >=5 and aggr(num(rank(sum(sum_val), 4)), Branch,Rank) <=10, Rank)

suppress null values