Most of the people may know about this already or have them already . But I would like to share this content with you. I see most of the new to qlikview developers face these questions initially when they first begin their career in any BI tool or Qlikview.
Script if anyone uses personal edition:
LOAD Salesman&SalesmanName as Filter_Salesman_No,
SalesmanName as SM_name
(biff, embedded labels, table is Sheet1$);
// The First table should be your table which records needed to be filtered . Here we have to load the Duplicate table which is given by your Business
(biff, embedded labels, table is Sheet1$)
Where not Exists(Filter_Salesman_No,Salesman&SalesmanName);
///if you do exists ... then it will pull on the filtered data...
drop table Fiter_table;
// We can drop the filter table. if we do not have to drop the filter table make sure you rename all the columns present in the filter table