Finding top 3 and bottom 3 records ?

[#1]

I'm a Qlickview greenhorn

i have requirement to show top 3 & Bottom 53spendValue regionwise. I knw to represent top 3 or Bottom 3 values in chart. But i have requiremnt to represent top&bottom3 records @ a time. is there any way to represent.......please help me

I'm ataaching a sample plz could anyone implement the code in it.

Regards

Mallikarjun

[swarup_malli · Accepted solution]

Mallikarjun,

Use this for  Max:

=IF (aggr(rank( sum(Value) ,0) , Value )<= 3 , sum(Value) )

Min column:

=IF (aggr(rank( sum(Value) ,0) , Value )> 3 , sum(Value) )

Regards

Swarup

[#3]

Thanks!!!! once again

It worked !!!!!