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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.