Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikviewaf
New Contributor III

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

Re: calculate only if > 0

Use something like

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

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

Re: calculate only if > 0

Other option is to use RangeMax()

RangeMax(YourExpression, 0)

Community Browser