Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pascos88
Contributor

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
Esteemed Contributor

Re: Sorting by expression in filter pane

Hi,

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

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

3 Replies
agigliotti
Honored Contributor II

Re: Sorting by expression in filter pane

you can use the below calculated dimension:

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


or


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

YoussefBelloum
Esteemed Contributor

Re: Sorting by expression in filter pane

Hi,

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

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

thiago_justen
Valued Contributor III

Re: Sorting by expression in filter pane

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
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser