Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ksenia_Vo
Contributor II
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
Vengatesh
Partner - Creator
Partner - Creator

Try this

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

You Know What To Do.
Anonymous
Not applicable

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