Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Ksenia_Vo
New Contributor II

Expression

Hello! What formula can I write to turn a negative number into a "0" and show positive numbers normally?

I need to have the value "0" when negative numbers appear

Labels (1)
2 Replies
Partner
Partner

Re: Expression

Try this

If([Your Expression]<=0,0,[Your Expression])

You Know What To Do.
Partner
Partner

Re: Expression

I would define in script

load *,
if (expression < 0, 0 expression) as newexpression
from/resident ....
 and then work with the newexpression and you keep the origin field