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

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AnthonyPSH
Contributor
Contributor

Sorting Expression Assistance

I'm new to Qlik and trying to sort summarized totals for groups based on years.  I'm having trouble getting the expression to work. The goal is to sort by the highest difference based on the UNSPSC.  Any help would be appreciated.  Thanks

AnthonyPSH_0-1770917997099.png

Labels (1)
1 Reply
Chanty4u
MVP
MVP

Try this 

Sum({<Year={"$(=Max(Year))"}>} Amount)

-

Sum({<Year={"$(=Max(Year)-1)"}>} Amount)