Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
kkkumar82
Specialist III
Specialist III

Sorting a Calculated dimension created using Aggr

All,

Just checking a small thing, when using Aggr as a calculated dimension.

I have created a Pivot table to top 3 salesman for each product.

I used aggr() for that but trying to sort the sales values in ascending but couldn't do that. I tired with new Sortable aggr() but no luck.

Any ideas would be great.

Attaching the application

1 Solution

Accepted Solutions
sunny_talwar

Is this what you want?

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Is this what you want?

Capture.PNG

kkkumar82
Specialist III
Specialist III
Author

Yes, Talwar Saab.

Really missed out checking Y Value.