Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
kalankun
Contributor
Contributor

How to use Exclusion in set set analysis?

Hi everyone,

I've googled but I cant understand how to find exclusion values in set analysis?

I have two tables, I concatenate them in one and used a flag ('table one'/' table two') so I could find some id which only one table has but I can't understand how to write it down

Labels (1)
1 Reply
Padma123
Creator
Creator

Hi,

You want id's which only table 1 is present is

Concat({<id=e({<flag={'table2'}>})>}id,',')

for table 2

Concat({<id=e({<flag={'table1'}>})>}id,',')