maximum salary in each department using the data load script.

[Purushothaman]

Hi Qlik Experts, 

Please help me to resolve this statement, in qliksense 

Load the attached excel sheet (MaxSalaryAccToDept) in Qlik Sense and find out the maximum salary in each department using the data load  script.

Thank you in advance.

[Lisa_P · Accepted solution]

Data:
LOAD
  Emp,
  Dept,
  Salary
FROM [lib://Data/MaxSalaryAccToDept.xlsx]
(ooxml, embedded labels, table is Sheet1);

MaxSalaries:
Load Dept,
  Max(Salary) as MaxSalary
Resident Data
Group By Dept;

[Purushothaman]

Thank you, for your swift solution.