Dependent sum based on two other fields

[APHardeau]

Hey everyone, 

I'm trying to make a summation field that is dependent on two other fields.

What I'm trying to do is have a sum of the Quantity, when the MatProduct is not Rental, Cylinder Type is Cyl and the Incoterms is Free Carrier (Collect).

After this I will make a sum of revenues (Mat_Revenue), where the MatProduct is not Rental.  Is the expression similar then? 

[MayilVahanan · Accepted solution]

HI @APHardeau 

Try like this

Sum({<MatProduct  -={'Rental'}>}Mat_Revenue)

For Quantity:

Sum({<MatProduct  -={'Rental'}, Cylinder Type = {'Cyl'}, FreeCarrier = {'Collect'}>}Quantity)

[APHardeau]

Those look like they will work, but I'm adding some data now. Will get back to you in a few hours!
In the meantime, is there a location where I can learn about the syntax for QlikSense?