Set Analysis: aggregation issue

[sifatnabil]

Hi, I have a table like this:

uniquetradeid	Type
11	V
12	V
11	V
13	V
13	V
15	V
15	V
15	V
16	V
17	E
17	V

I want to translate the following to set analysis so that I can represent this in both text boxes and graphically:

E = distinct count of uniquetradeid which has no V in another row with the same uniquetradeid.

V = distinct count of uniquetradeid which has no E in another row with the same uniquetradeid.

H = distinct count of uniquetradeid which includes both E AND V in its rows.

So in the example, the results should be

E=0,

V= 5,

H=1

How can I get this with set analysis both in text box and graphically? Thanks.

[anbu1984 · Accepted solution]

=Count(DISTINCT {<uniquetradeid=P({<Type={'E'}>})>-<uniquetradeid=P({<Type={'V'}>})>} uniquetradeid)

=Count(DISTINCT {<uniquetradeid=P({<Type={'V'}>})>-<uniquetradeid=P({<Type={'E'}>})>} uniquetradeid)

=Count(DISTINCT {<uniquetradeid=P({<Type={'E'}>})>*<uniquetradeid=P({<Type={'V'}>})>} uniquetradeid)

[MK_QSL]

=COUNT({<Type = {'E'}, uniquetradeid = E({1<Type = {'V'}>})>}Distinct uniquetradeid)

=COUNT({<Type = {'V'}, uniquetradeid = E({1<Type = {'E'}>})>}Distinct uniquetradeid)

=COUNT({<Type = {'E'}, uniquetradeid = P({1<Type = {'V'}>})>}Distinct uniquetradeid)