Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

To Find Users that exists in MySingle Table & not in Section access & Custom Directory

Hi Frnds,

I have 3 tables :-

1) Section Access:

     NTNAME, Flag

'1' as Flag

2) Custom Directory:

     NTNAME, Flag

'2' as Flag

3) MySingle Table:


'3' as Flag

Provided Dummy Data.

I need to find those :-

a) users which exists in mysingle table & not in Section Access,Custom Directory

b) users which exists in Section Access & not in mysingle table,Custom Directory

c) users which exists in Custom Directory & not in mysingle table,Section Access