Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Excluding values in Set Analysis

I need some help with set analysis.

Please exclude the B = 1 and C = 1 if it's possible in one set analysis statement.

Screenshot_2.jpg

Thank you!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe

Sum({<E={X}>-<B ={1},C={1}>} D)

Note that your two expressions both contain the first record, hence your sum is +1.

View solution in original post

1 Reply
swuehl
MVP
MVP

Maybe

Sum({<E={X}>-<B ={1},C={1}>} D)

Note that your two expressions both contain the first record, hence your sum is +1.