Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUMIF formula in Chart expression

sum(if(Quantity>=Seats),Quantity) what am I doing wrong.

I want the chart to sum for only those deals where the Quantity is greater than the variable Seats. I tried it iwth the ,0) at the end and still didn't work.

3 Replies
Not applicable
Author

Change brackets...

SUM( IF(Quantity >= Seats,Quantity))

Not applicable
Author

will the same thing work for summing only those that are maximum date.

I have data by day for ending inventory but I want the chart to only sum the last date's data:

sum (if(Date = Max(Date),Cost)) but it doesn't work

skaredovs
Partner - Creator
Partner - Creator

dcpy, you need to use Total for Max() in this case:

sum (if(Date = Max(total Date),Cost))

BR