QlikSense Sumif function

[#1]

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

A	B
1	1
0	1
1	0
1	0
1	1
0	1

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.

[jagan]

Hi,

Try this expression

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

Regards,

Jagan.

[Anonymous]

Hi try like this

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

[#4]

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

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