Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
APHardeau
Contributor II
Contributor II

Dependent sum based on two other fields

Hey everyone, 

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

Untitled.png

 

 

 

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? 

1 Solution

Accepted Solutions
MayilVahanan

HI @APHardeau 

Try like this

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

 

For Quantity:

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI @APHardeau 

Try like this

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

 

For Quantity:

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
APHardeau
Contributor II
Contributor II
Author

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?