Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table - Sort by Rank within Dimensions

I have a pivot table that I am trying to sort by rank. However, I am not able to sort by rank even when I add the rank expression to the sort expression. 

Is there any way to sort in context rather than globally? Has there been any workarounds since the post: http://community.qlik.com/ideas/1480 ?

QV Sorting.png

1 Reply
marcus_sommer

If the normal sorting didn't work you could try it with dual() for the dimension:

dual(Country, RankExpression)

Have a look on posts like: Re: Sort on straight table using class function

- Marcus