topic Re: Bottom five values using rank function in QlikView

Bottom five values using rank function

varunreddy — Mon, 09 May 2016 15:50:04 GMT

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?

Thanks in advance!

Regards,

Varun.

Re: Bottom five values using rank function

Gysbert_Wassenaar — Mon, 09 May 2016 15:51:37 GMT

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

Re: Bottom five values using rank function

varunreddy — Mon, 09 May 2016 15:53:45 GMT

Gysbert,

Thanks for your quick response.

Cheers!

Varun