How to display top ten employees with sales or salary

[Donthamsetty10]

pls suggest me crt expression I'm new to qlik sense

[sidhiq91]

@Donthamsetty10  Please use the below expression in your Dimension:

=Aggr(if( rank(sum(Year Salary))<=10,Employee Name),Employee Name)

This should resolve the issue. 

If yes, please like and accept it as a solution.

[Donthamsetty10]

It didn't display anything. My issue isn't resolved.

 

[sidhiq91]

@Donthamsetty10  Please replace your Dimension Name with the correct Dimension Name from your script. It should display the correct result.

[SchalkF]

Hi Like @sidhiq91  said, your dimension name is EmployeeName, and not Employee Name

[Donthamsetty10]

I corrected it, but still it's not displaying..

[Donthamsetty10]

It's displaying the employee names in rank field, instead of rank numbers

[Donthamsetty10]