QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Creator III

Bottom five values using rank function

Hi Guys,

I have found top 5 values using rank in the expression

Only({<MonthYear>} aggr(sum({<MonthYear,

Name = {"=rank(sum({<MonthYear= {'\$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-(
[Total Number of Failing Records]/[Total Number of Records])),MonthYear,Name))

Now I am trying to find bottom 5 values using the rank.

Can anyone help me with this?

Regards,

Varun.

1 Solution

Accepted Solutions

Try the rank of the value multiplied by -1:

Only({<MonthYear>} aggr(sum({<MonthYear,

Name = {"=rank(-sum({<MonthYear= {'\$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-(
[Total Number of Failing Records]/[Total Number of Records])),MonthYear,Name))

talk is cheap, supply exceeds demand
2 Replies

Try the rank of the value multiplied by -1:

Only({<MonthYear>} aggr(sum({<MonthYear,

Name = {"=rank(-sum({<MonthYear= {'\$(vCurMonthYear)'}>}1-([Total Number of Failing Records]/[Total Number of Records])))<=5"}

>}1-(
[Total Number of Failing Records]/[Total Number of Records])),MonthYear,Name))

talk is cheap, supply exceeds demand
Creator III
Author

Gysbert,