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

QlikSense Sumif function

Hi new to qliksense and I am trying to add the values in one column based on the flag in another.

AB

1

1
01
10
10
11
01

I want to add up column B based on what is in Column A. I want to Sum all values in together in B where they have a value 1 in column A.

in this scenario the sum should be 2.

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

=Sum({<A={1}>} B)

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi try like this

=Sum(If(A=1,A)B)

Not applicable
Author

hi, I had a similar need in Qliksense, this following worked for me

=Sum(if(='1',[Sum of B]))