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: 
bronsonelliott
Partner - Contributor III
Partner - Contributor III

Problems sorting a pivot table

I hope someone can help.  I'm trying to sort a pivot table and it's giving me fits!!!

I'm pulling some data from a database.  Included in this data is a sort field called 'Sort'.  This field is a numeric field.

I have a pivot table using the data from this database and I want to sort the data by the 'Sort' field but I don't want to show the sort field.  So I thought I could use a n expression to do this but I'm getting some inconsistent results.

If you see in the screen shot, I've included the Sort field just to visualize what's going on.  I have the sort expression of sum(Sort) on the "Section", "Grouping" and "Metric" fields but it's still acting weird.  I've tried different combinations of using the expression on only 1 field but I still get inconsistent results.

Please help!!

sort.jpg

1 Reply
bronsonelliott
Partner - Contributor III
Partner - Contributor III
Author

I may have figured it out.  I tried using Max(Sort) and it seems to be working.  Not sure why so if anyone wants to chime in please do so.