Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kdm52rus
Contributor
Contributor

exclude entire set if one item has predifined value

Hello!

Here is what i got:

example.PNG

I have a list of items, dates and states. i want that if some dimension got state with some predefined value then all values got excluded.

So in example above dimension2 got 0 and i want to exclude everything(0, 2 and 1) because there is a zero in set.

Can i somehow achieve that? (via set analysis?)

Thanks in advance!

1 Solution

Accepted Solutions
sunny_talwar

You might need to use Aggr() function here

Sum(Aggr(If(Count({<dimension2 = {0}>} dimension2) = 0, Sum(Measure)), dimension0, dimension1, dimension2))

View solution in original post

4 Replies
sunny_talwar

You might need to use Aggr() function here

Sum(Aggr(If(Count({<dimension2 = {0}>} dimension2) = 0, Sum(Measure)), dimension0, dimension1, dimension2))

rubenmarin

Or maybe:

Sum(Aggr(If(Count(TOTAL <dimension0, dimension1> {<dimension2= {'0'}>} dimension2) = 0, Sum(measure)), dimension0, dimension1))

kdm52rus
Contributor
Contributor
Author

Thanks! Thats exactly what i need.

kdm52rus
Contributor
Contributor
Author

Thank you for your answer! Unfortunately i can mark only one reply as answer =| Marked as helpful though.