Set analysis - Clients with one value but not another

[brunosantos]

Hello.

I've been trying but until now I haven't been able to get it right.

Also reading the help on Set Analysis ... still confused (newbie on this).

Let's say I have a table of clients and there Languages.

LOAD * INLINE [

CLIENT, LANGUAGE

A, EN

A, DE

A, PT

B, BR

B, PT

B, EN

C, EN

D, DE

];

If I try to find the number of Clients that speak EN.

Set Analysis:

          =Count({1<LANGUAGE={'EN'}>}CLIENT)

I get the value 3 - Which is OK (Clients A, B and C speak EN)

But let's say I want the number of Clients that speak EN, but do not speak DE.

Set Analysis I've been trying:

          =Count({1<LANGUAGE={'EN'}-{'DE'}>}CLIENT)

Here I also get the value 3, which is not OK. I should receive value 2 (Clients B and C speak EN but not DE - Client A speaks both Languages).

I believe this should be fairly simple (I hope), but I not getting there.

Thanks a lot in advance.

Best Regards,

Bruno.

[Anil_Babu_Samineni]

Even, Client A also speaks EN Language. Why don't you need this?

[RSvebeck]

Try this:

Count({1<LANGUAGE={'EN'},

CLIENT=e({1<LANGUAGE={'DE'}> CLIENT)

>}CLIENT

[neelamsaroha157]

Try this

Count({$<CLIENT=E({1<LANGUAGE={'DE'}>}CLIENT)* P({1<LANGUAGE={'EN'}>})>}CLIENT)

[Anonymous · Accepted solution]

Hi Robert, you forgot something:

=Count({1<LANGUAGE={'EN'},CLIENT=e({1<LANGUAGE={'DE'}>} CLIENT)>}CLIENT)

[trdandamudi]

One of the way is as below:

[brunosantos]

Problem solved. Thanks for your time and help.

Bruno.

[brunosantos]

Thanks Robin Hausdörfer and Robert Svebeck for your answers.

Bruno.