How to use Exclusion in set set analysis?

[joyan]

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

[F_B]

Hi @joyan , welcome to the community!

My advice is to take a look at official documents like this: Set analysis | Qlik Sense on Windows Help

If you still have troubles try to add more context to your request .

Have a nice day

[Padma123]

Try this...

Concat({

<id=e({<flag={'table1'}>})>
+
<id=e({<flag={'table2'}>})>

}id,',')

[Vegar]

What do mean by "write it down"? Please explain you expected output.

One suggestion is to use a measure like this:

concat(distinct {<id={"=count(distinct flag)=1"}>}id, ', ')

[Padma123]

for example 

take some sample data after concatenate table data is

table1:

id,flag

1,table1

2,table1

2,table2

3,table2

<id=e({<flag={'table1'}>})> means other than 1,2(3 is result)  ,

<id=e({<flag={'table2'}>})> means other than 2,3(1 is result) 

[Kushal_Chawda]

@joyan  If you want to find out IDs which are available only in Table1 then you can use below set

Count({<ID=e({1<TableFlag={'Table 2'}>})>}distinct ID)

If you want to find out IDs which are available only in Table2 then you can use below set

Count({<ID=e({1<TableFlag={'Table 1'}>})>}distinct ID)

You can use the same set in your required measure