Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

calculate only if > 0

Hi,

there's a way to calculate the delta sales, only if the result of the calculation is greater than 0 ?

I don't want to have on my graph negative value.

Thank you

forum 2.png

2 Replies
Colin-Albert

Use something like

     if([your expression] > 0, [your expression])

Your screen-shot was truncated so I cannot use the exact expression from your example.

sunny_talwar

Other option is to use RangeMax()

RangeMax(YourExpression, 0)