Hi new to qliksense and I am trying to add the values in one column based on the flag in another.
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.
Try this expression
Hi try like this
hi, I had a similar need in Qliksense, this following worked for me
=Sum(if([A]='1',[Sum of B]))
Retrieving data ...