Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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