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: 
Anonymous
Not applicable

How to show top 5 and last 5 and middle 5 sales for partnerid's

Hi ,

I have data like Partner id wise sales values in straight table.But in this table i want see only top5 sales and bottom 5 sales and middle 5 sales with partnerid's.

Below is the straight table i have attached can you please explain how can i show above requirement matches.

Thanks,

Raj

1 Solution

Accepted Solutions
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Rajesh,

for Top 5 And bottom 5 Please find the attachment.

and explain the logic how you calculate middle 5 one.

Thanks,

Arvind Patil

View solution in original post

4 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Rajesh,

for Top 5 And bottom 5 Please find the attachment.

and explain the logic how you calculate middle 5 one.

Thanks,

Arvind Patil

its_anandrjs

You can find rank by the expression

=Rank(Aggr(Sum(Sales),PartnerID))

Top 5

=If( Rank(Aggr(Sum(Sales),PartnerID)) <= 5, Sum(Sales))


Bottom 5


=If( Rank(Aggr(Sum(Sales),PartnerID)) >= 5, Sum(Sales))


Note:- How you can identify the middle 5 sales.

Anonymous
Not applicable
Author

Thanks Anand..it's working fine

Anonymous
Not applicable
Author

Thanks Arvind..it's working fine