Aggregation Functions

[#1]

hai alllllll

please Explain about Aggregation Functions with examples.how to find out the top 5 sales in product table and also each category sum,min,max,avg sales......

table fields are  category,product,sales like

[Anonymous]

See QlikView Technical Brief - AGGR for more information on the AGGR function.

The formula you are looking for is:

IF( AGGR( RANK( SUM( sales) ), product) <=5,product)

[jagan]

Hi,

Try like this

Dimension : IF( Aggr( Rank( Sum( Sales), 4 ), Product) <=5, Product)

Expression : Sum(Sales)

Regards,

Jagan.