Need to display the Top 5 Amount for that Year in the report

[#1]

Hi,

These are the Column names(DataSource):

CUSTOMER NAME

USER ID

LOCATION

SCHEME

CIRCLE

ZONE

TARRIF AMOUNT

NO OF MONTHS

ACTIVATION_DATE

EXPIRY_DATE

AVERAGE AMOUNT

Based on "CIRCLE" (filter condition) i need to display the Top 5 Average Amount of SCHEME for that Year.

How to achieve this?

[hectorgarcia]

in the GUI build a calculated dimension using the function rank

hector

[#3]

Hi,

     You can do that using chart properties, on presentación tab, and ordering the expresión result.

I hope help you

[#4]

Hope below post helps!

http://community.qlik.com/thread/58136?tstart=60