Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fadibouchnak
Contributor
Contributor

Equivalent of Excel's SUMIFS in Qlik Sense

I have data by persons and by date

I'm looking for an equivalent of Excel's SUMIFS function in Qlik Sense, as I would like to calculate a sum of a field "A" per person, if the sum of another field "B" for the whole day is not equal to 0.

Something like this :

if(sum of B for the day <> 0, A, 0) //which I don't know how to do 

I'm not sure if this can be done in the script, or directly in a table object?

Thanks for helping!

P.S. : my excel function goes like that :

=SI(SOMME.SI.ENS(CW:CW;A:A;A8)=0;0;CY8) where CW:CW is "B" column, A:A is the date column and CY is the "A" column

Labels (4)
0 Replies