Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
flo2
Contributor III
Contributor III

Multiple different of in set analysis

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 😛

1 Solution

Accepted Solutions
Saravanan_Desingh

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)

View solution in original post

2 Replies
Saravanan_Desingh

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
Contributor III
Contributor III
Author

exactly, thanks a lot 🙂