topic Re: How to use Exclusion in set set analysis? in Qlik Replicate

How to use Exclusion in set set analysis?

woungchi3 — Sun, 25 Aug 2024 11:11:24 GMT

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

Re: How to use Exclusion in set set analysis?

john_wang — Sun, 25 Aug 2024 11:38:16 GMT

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.

Re: How to use Exclusion in set set analysis?

Padma123 — Sun, 25 Aug 2024 12:37:33 GMT

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)

Re: How to use Exclusion in set set analysis?

john_wang — Sun, 25 Aug 2024 15:10:52 GMT

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.