maximum salary

[qlikview979]

Hi experts,

How to find out the department wise maximum salary ? what is the syntax ?

[MK_QSL]

If you want Maximum Salary of an Employee by Department...

use as below

Max(TOTAL <Department> Aggr(SUM(Salary),Department,Name))

or simply

=Max(Aggr(SUM(Salary),Department,Name))

[sunny_talwar]

Are you looking for something in the front end or back end of the application??

Sunny