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: 
Anonymous
Not applicable

Using an expression for Countif conditions

Hey everybody,

I am trying to run a CountIf wherein whenever the SUM of A,B and C equals 1, D is counted.

For example, in the below picture, I should get a count of 3.

Qlikview countif.PNG

I tried a few expressions including the following one  =Count({<A+B+C=1>} D), but don't seem to get a result.

Would appreciate if I could get your thoughts on this.

Thanks in advance

2 Replies
sunny_talwar

May be this

Sum(If(RangeSum(A, B, C) = 1, D, 0)

shiveshsingh
Master
Master

Try Rangesum function, already suggested by Sunny, The Savior