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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chematos
Specialist II
Specialist II

Rank min and max values

Hi,

I want to do a ranking of the top X and the less top Y, you know? The X max values and the Y min values of a chart.

IF(AGGR(RANK(SUM([SSTT kg])), [SSTT kg]) <= $(Nmax), [SSTT kg],

IF(AGGR(RANK(SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg]))

I need to change the second IF to get a number of minimum values

Any help would be appreciated.

Regardas,

Chema

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try to rank for -sum([SSTT kg]):

IF(AGGR(RANK(-SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg])

View solution in original post

3 Replies
swuehl
MVP
MVP

Try to rank for -sum([SSTT kg]):

IF(AGGR(RANK(-SUM([SSTT kg])), [SSTT kg]) <= $(Nmin), [SSTT kg])

chematos
Specialist II
Specialist II
Author

I had thought something like that but I haven´t faith in a solution so easy....

Thank you swehl !!!

Srinivas
Creator
Creator