topic Re: set analysis sum field > 0 in QlikView

set analysis sum field > 0

chematos — Tue, 02 Jul 2013 15:52:31 GMT

Hi,

I have the next issue:

I need to sum a field (Amount), but only when the amount is positive and this expression is not working.

I know that the same expression with different fields, works, but with the same field... it seems to be a problem

sum({$<Amount={">=0"}>}Amount)

Thank you,

Regards

Chema

swuehl — Tue, 02 Jul 2013 15:57:47 GMT

Well, yes. How we are supposed to help here?

This should work (as you said yourself, and I can't see a reason why this shouldn't work given the information you posted).

suepenick — Tue, 02 Jul 2013 21:08:39 GMT

use an if

sum(if(Amount>0, Amount))