Conditional Filtering of table based on column from another table

[vizz3108]

I am a newbie in qlikview. Please help. This is my data model.

My requirement is to filter the table "data" for only those clients which are present in clientname field in "Master" table for a given manager. Solution can be either in front end or backend. Thanks in advance.

[brunobertels]

hi 

try this :

with a left join 

Data:

load

ManagerName,

Region,

Product,

Client

from ... 

left join(Data)

load

ManagerName,

ClientName,

Revenue

from ... 

Or this with an where  exists statement 

Master:

load*

from...

Data:

load*

from ...

where exists(ManagerName,ManagerName);

have a look in help site at join left join and where exists clause fo further details