topic Set in QlikView

Set

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi all iam trying to count the key , where Status is not equaul to Class, Student and name... Other than this it has to count everything

Is this expression correct ?

=count(distinct {<Status -= {'class','name','Student'}>}Key)

tresB — Tue, 24 Oct 2017 07:19:58 GMT

Looks correct.

its_anandrjs — Tue, 24 Oct 2017 07:20:04 GMT

Yes expression is correct

Set Analysis

=count(distinct {<Status -= {'class','name','Student'}>}Key)

With If you can do this way

If condition

=Count(distinct if(Not Match(Status,'class','name','Student'), Key))

pradosh_thakur — Tue, 24 Oct 2017 07:23:00 GMT

Hi John

if the editor shows you red ignore it.

please go through this once to avoid confusion in future in case of case sensitivity etc.