Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Try this

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

You Know What To Do.
Highlighted
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