topic Need to filter data using two tables in a script in QlikView

Need to filter data using two tables in a script

Mon, 07 Sep 2009 20:42:15 GMT

I have two tables one employees and the other departments. I have used these with others to get what I want and filtered the department table. There is however no way I can filter the employee table on it's own. If I link it to the department table in the script then I can use the description fiels as I already do for the department table.

question is what syntax do I need ot use to pull the data from both tables in the script, there is of course a field called department in each table to connect them.

Need to filter data using two tables in a script

Mon, 07 Sep 2009 21:08:29 GMT

tblEmployees:

LOAD

EmpID,

EmpName,

DeptID;

SQL SELECT *

FROM tblEmployees;

Left join (tblEmployees)

LOAD

DeptID,

DeptName;

SQL SELECT *

FROM tblDept;

Need to filter data using two tables in a script

Mon, 07 Sep 2009 21:51:33 GMT

Thanks for that, I had to reverse my tables around though so the department is used with the left join to remove the unwanted entries.