topic How to Show top 10 values for each group? in QlikView

How to Show top 10 values for each group?

Fri, 08 Aug 2014 15:34:48 GMT

Hi,

i have 3 fields

manager ,employee, salar

for under each manger i want show top 10 salryed employess in in straight or pivot table

Please help me on

Thanks,

JonnyPoole — Fri, 08 Aug 2014 15:52:24 GMT

For a straight table try this as the expression to show top 10 Salaries for each manager

if( aggr( rank( sum( Salary)),Manager,Employee) <=10, sum(Salary))

to actually show the rank as well

if( aggr( rank( sum( Salary)),Manager,Employee) <=10, aggr( rank( sum( Salary)),Manager,Employee))

MK_QSL — Fri, 08 Aug 2014 15:59:28 GMT

Dimension

1) Manager

2) IF(Aggr(Rank(SUM(Salary),4),Manager,Employee)<=10,Employee)

Expression

SUM(Salary)

maxgro — Fri, 08 Aug 2014 16:02:33 GMT

in a straight table you can also use dimension limit (in dimension limits tab)