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

Top 2 Clients for each Group

Hello friends,

I have following table

Group
ClientSales
ACa1500
ACa2400
ACa3600
ACa4200
B

Cb1

300
BCb2250
BCb3350

Now my requirement is to find top 2 client for each group by sales,the output table must be like

GroupClientSales
ACa3600
ACa1500
BCb3350
BCb1300

Thanks in advance for everyone's idea and reply..

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

Hi bhawna gupta,

Have a look at the attachment, I think it's what you are looking for.

Kind Regards,


Cesar

View solution in original post

1 Reply
cesaraccardi
Specialist
Specialist

Hi bhawna gupta,

Have a look at the attachment, I think it's what you are looking for.

Kind Regards,


Cesar