Discussion Board for collaboration related to Creating Analytics for QlikView.
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
If([Your Expression]<=0,0,[Your Expression])
I would define in script
load *,if (expression < 0, 0 expression) as newexpressionfrom/resident .... and then work with the newexpression and you keep the origin field