topic Re: Select Top 5 By Branch, By Sales in QlikView

Select Top 5 By Branch, By Sales

Mon, 25 May 2015 13:08:13 GMT

HI Experts

I have a following scenario,

I have a sales table by Branch

Now I want to chose Top 5 Customers By each Branch, By Sales

Please Help

Re: Select Top 5 By Branch, By Sales

prajapatiamar38 — Mon, 25 May 2015 13:14:50 GMT

Hi,

John Please use this expression used below.

By Sales,

=IF(Aggr(Rank(Sales),Cust_ID)<=5,Sales)

By Branch,

=IF(Aggr(Rank(Branch),Cust_ID)<=5,Branch)

Thanks.

Re: Select Top 5 By Branch, By Sales

Mon, 25 May 2015 13:21:25 GMT

Hi,

You can use input box .

See attached qvw.

Re: Select Top 5 By Branch, By Sales

prajapatiamar38 — Mon, 25 May 2015 13:30:36 GMT

Hi,

yes we can use input box but in that case we have to use two input box one for sale and one for branch.

Re: Select Top 5 By Branch, By Sales

Mon, 25 May 2015 13:36:54 GMT

How Can I do this in Script Level

I got sales Tables by month wise for last one year

Please Suggest;

Re: Select Top 5 By Branch, By Sales

Kushal_Chawda — Mon, 25 May 2015 13:45:01 GMT

Please see the attached file

Re: Select Top 5 By Branch, By Sales

ecolomer — Mon, 25 May 2015 13:45:06 GMT

See this example

Re: Select Top 5 By Branch, By Sales

ecolomer — Mon, 25 May 2015 13:46:16 GMT

And this

Re: Select Top 5 By Branch, By Sales

pratap6699 — Mon, 25 May 2015 19:30:57 GMT

expression-->=if(aggr(rank(sum(sales)<=5),sales,[optional])

Re: Select Top 5 By Branch, By Sales

Oleg_Troyansky — Mon, 25 May 2015 21:31:48 GMT

See my blog on this subject:

Q-Tip #8 – Ranking the Unrankable | Natural Synergies

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!