Discussion board where members can get started with QlikView.
I have a straight table with expressions. One of my expression is returning positive and negative amounts.
I need the negative amount to be set at 0€.
Is it possible to do it in the Number / Format tab ?
(I know I can put an "IF" in my expression to say "If amount < 0 then 0 else amount" but I want to avoid IF in my expression.
Thanks for your help
Go to Solution.
With out IF i don't think it is possible
Without using if you can use mapping load in the script part and may those values and make calculation on the script part.
Hope this helps
It might be, using RangeMax()
Thanks it works