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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sureshmaddipati
Contributor III
Contributor III
‎2024-04-18 01:56 AM

Sorting

I have region field as dimension i would like to sort it based highest value we have hierarchy in place under region country and entities 

Labels (1)
Labels
283 Views
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2024-04-18 02:11 AM

Perhaps try this with sort expression in descending order.

Aggr(Rank(Sum(Value)), (Region, (Text, DESCENDING)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
279 Views
0 Likes