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: 
shraddha6369
Contributor II
Contributor II

Sorting in Table ( Top three based on a Measure and group by Dimension)

Hello Friends,

I have a requirement where i need to show data in a sorted order in a Straight table.

Data:

load * inline [

Client, Product, Total

G, A, 1000

G, B, 2000

DB, A, 500

DWES, x, 1500

MS, y, 200

AGG, z, 1000

DB, B, 2000

];

 

Required output in a Table:(top 3 clients  , sorted on total by group by client)

Client  Product   Total

G              B               2000

G               A               1000

DB            B                2000

DB            A               500

DWS        X              1500

This has to be done in front end. I am trying combinations of aggr and rank but could not get  the required output. Any help will be much appreciated.

Thank you.

1 Solution

Accepted Solutions
sunny_talwar

2 Replies
sunny_talwar

Check this out

Capture.PNG

shraddha6369
Contributor II
Contributor II
Author

Thank you so much for the quick reply. It worked as per my requirement.