Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

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