Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

chematos
Valued Contributor II

set analysis sum field > 0

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

Tags (2)
2 Replies
MVP
MVP

Re: set analysis sum field > 0

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
Contributor

Re: set analysis sum field > 0

use an if

sum(if(Amount>0, Amount))

Community Browser