topic Re: Multiple different of in set analysis in QlikView

Multiple different of in set analysis

flo2 — Tue, 18 May 2021 22:34:15 GMT

Hello

I learned by this forum that we could use

-= to do an exclusion in set analysis but when i try to use it with a or to make 2/3 excluding that doesn't work

if Someone could make me learn how to make work multiple excluding in set analysis ? 😛

Thanks a lot for reading 😛

Saravanan_Desingh — Wed, 19 May 2021 01:41:35 GMT

Are u looking something like this?

=Count({<Field1-={'A','B','C'}>} Field1) The above will remove NULLs also. =Count({<Field1={"=Not Match(Field1,'A','B','C')"}>} Field1)

flo2 — Thu, 20 May 2021 22:27:36 GMT

exactly, thanks a lot 🙂