Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER 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
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

Hi,

You can use input box .

See attached qvw.

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

Hi

How Can I do this in Script Level

I got sales Tables by month wise for last one year

Please Suggest;

MVP
MVP

Please see the attached file

Master II
Master II

See this example

Master II
Master II

And this

Creator
Creator

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

MVP & Luminary
MVP & Luminary

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!