Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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])

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