reg-var

[#1]

1. can u say one thing if i have 100 records and i want to display top 5 records and low 5 records

[tresB]

You might have to use rank() alongwith aggr(). Sample qvw could help me help you.

[preminqlik]

sum({<Dimension={'=sum(aggr(rank(sum([BASIC AMOUNT]))<6,Dimension))'}>}[BASIC AMOUNT])      top 5

sum({<Dimension={'=sum(aggr(rank(-sum([BASIC AMOUNT]))<6,Dimension))'}>}[BASIC AMOUNT])      bottom 5

[anbu1984]

Check this