Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this expression
=Sum({<A={1}>} B)
Regards,
Jagan.
Hi try like this
=Sum(If(A=1,A)B)
hi, I had a similar need in Qliksense, this following worked for me
=Sum(if(='1',[Sum of B]))