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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.