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: 
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