Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pascos88
Creator II
Creator II

Sorting by expression in filter pane

Hi,

In a filter pane I have a list of 'Team'.

each team has an associate dimension 'Win Year'.

Now in the filter pane, I want sorting for the recent 'Win Year'..

How could be a function ?

Best,

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this on the sorting expression (check just the expression):

=Max([Win Year]) //with descending

View solution in original post

3 Replies
agigliotti
Partner - Champion
Partner - Champion

you can use the below calculated dimension:

Aggr( Only(Team), ([Win Year], (NUMERIC), (DESCENDING)))


or


Aggr( Only(Team), (Team, (=Max([Win Year]), DESC )))

YoussefBelloum
Champion
Champion

Hi,

try this on the sorting expression (check just the expression):

=Max([Win Year]) //with descending

Thiago_Justen_

What about sort numerically?

Click the dimension or measure name (in your case, year) to open the settings and click the sorting button to switch to Custom sorting. Then select sort numerically. The sorting is either Ascending or Descending.

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago