topic Re:SUMIF formula in Chart expression in QlikView

SUMIF formula in Chart expression

Sat, 10 Oct 2009 02:35:40 GMT

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.

SUMIF formula in Chart expression

Sat, 10 Oct 2009 02:44:44 GMT

Change brackets...

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

Re:SUMIF formula in Chart expression

Thu, 15 Oct 2009 10:00:58 GMT

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

Re:SUMIF formula in Chart expression

skaredovs — Thu, 15 Oct 2009 13:57:09 GMT

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

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