Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Tags (1)
3 Replies
MVP
MVP

Re: QlikSense Sumif function

Hi,

Try this expression

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

Regards,

Jagan.

venkatasreekant
Valued Contributor

Re: QlikSense Sumif function

Hi try like this

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

Not applicable

Re: QlikSense Sumif function

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

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

Community Browser