Set Analysis Help

hjm35055 — Thu, 01 Feb 2018 12:30:21 GMT

Hi,

I have data that looks like below. In a text box, I am trying to create an expression that shows the number of 100% VALID entities. So with the example below, my answer would be 1. I originally was doing =Count(DISTINCT {<[Validity Check] = {'Valid'}>} [Entity ID]. However this does not work because it is counting entity 1 and 2. I loaded [Validity Check] as a dual Valid,0 and Invalid,1 in the script thinking I could do some set analysis that says count distinct entity ID where the sum([Validity Check] = 0. But could not figure out how to get that expression working. Any help is appreciated. Thanks!

Re: Set Analysis Help

sunny_talwar — Thu, 01 Feb 2018 12:57:01 GMT

May be try this

=Count(DISTINCT {<[Entity ID] = e({<[Validity Check] -= {'Valid'}>})>} [Entity ID]

or this if Validity Check can only ever be Valid or Invalid

=Count(DISTINCT {<[Entity ID] = e({<[Validity Check] = {'Invalid'}>})>} [Entity ID]

topic Re: Set Analysis Help in QlikView

Set Analysis Help

Re: Set Analysis Help