Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select Top 5 By Branch, By Sales

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

9 Replies
prajapatiamar38
Creator II
Creator II

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.

Not applicable
Author

Hi,

You can use input box .

See attached qvw.

prajapatiamar38
Creator II
Creator II

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.

Not applicable
Author

Hi

How Can I do this in Script Level

I got sales Tables by month wise for last one year

Please Suggest;

Kushal_Chawda

Please see the attached file

ecolomer
Master II
Master II

See this example

ecolomer
Master II
Master II

And this

pratap6699
Creator
Creator

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

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!