topic Expression in QlikView

Expression

Ksenia_Vo — Sat, 16 Nov 2024 03:27:53 GMT

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

Re: Expression

Vengatesh — Mon, 27 May 2019 13:09:10 GMT

Try this

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

Re: Expression

Anonymous — Mon, 27 May 2019 13:14:57 GMT

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