Employee lists

[rassanbekov]

Hello!

I have faced the problem. There are two lists of employees.

First contains the employee names for all departments.

The second contains only one department employees.

The data should be filtered by the one department employee only.

When I use "as" in script, the employees are properly matched. But the data for other employees are also loaded. How can I stop loading the data for all employee in Qlikview?

[d_prashanthredd]

All_Departments:

LOAD [Department name] as Department,

     [Employee name] as Employees,

     [Other details],

     Salary

FROM

(ooxml, embedded labels);

Inner Join    (All_Departments)

Specific_Department:

LOAD Department,

     Employees

FROM

(ooxml, embedded labels, table is Sheet1);

[rassanbekov]

Worked out! Thank you!

[d_prashanthredd]

Awesome.. Mark the appropriate solution as "Correct" or "Useful"