Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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)
=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)
=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)