Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner
Partner

maximum salary in each department using the data load script.

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.

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

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;

View solution in original post

2 Replies
Lisa_P
Employee
Employee

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;

View solution in original post

Purushothaman
Partner
Partner
Author

Thank you, for your swift solution.