topic Re: Conditional Filtering of table based on column from another table in App Development

Conditional Filtering of table based on column from another table

vizz3108 — Thu, 27 May 2021 06:32:04 GMT

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.

Re: Conditional Filtering of table based on column from another table

brunobertels — Thu, 27 May 2021 08:37:38 GMT

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