Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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])

View solution in original post

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