topic Re: Set Analysis: aggregation issue in QlikView

Set Analysis: aggregation issue

sifatnabil — Thu, 16 Oct 2014 10:38:30 GMT

Hi, I have a table like this:

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 — Thu, 16 Oct 2014 10:48:27 GMT

=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 — Thu, 16 Oct 2014 10:49:00 GMT

=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)