sumif

Mon, 17 Mar 2014 21:47:54 GMT

Hello,

I have a straight table with one dimension, “ITEM”. “Date”, “PO Rec Date”, “Net Units”, and “PO Rec Date” are field names. For every item, I need to sum all “Net Units” sales that occurred after the Max of the “PO Rec Date” field, of this particular item. Namely, every sale with a “Date” value above the Max of “PO Rec Date”. Every item (dimension value) has a different Max of “PO Rec Date”.

That is why the following expression doesn't work (because it takes the absolute max of “PO Rec Date”😞

sum({$<Date={">=$(=max([PO Rec Date]))"}>}[ Net Units])

But for some reason this expression doesn't work either:

sum(if(Date>=max([PO Rec Date]),[Net Units],0))

Any ideas?
Thanks

Re: sumif

swuehl — Mon, 17 Mar 2014 23:28:50 GMT

You probably need advanced aggregation, something like

=sum(aggr(if(Date>=max(total<ITEM> [PO Rec Date]),[Net Units],0), ITEM, Date))

topic Re: sumif in QlikView

sumif

Re: sumif