How to use Exclusion in set set analysis?

[woungchi3]

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

[john_wang]

Hello @woungchi3 ,

Welcome to Qlik Community forum and thanks for reaching out here!

Seems I did not get the question well. Would you please elaborate it, it's better with a sample and the expected results.

thanks,

John.

[Padma123]

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

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

result: it will exclude table2 id +matching id's between the 2 table(result is unique values from table 1)

for table 2

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

result: it will exclude table1 id +matching id's between the 2 table(result is unique values from table 2)

[john_wang]

Thank you for the help @Padma123 . would you please confirm the product name? if it's QDA products then we will move the article to Sense forum area.