topic Re: Negative values as '0' in QlikView

Negative values as '0'

mohan2391 — Wed, 16 Dec 2015 11:19:42 GMT

how can i display negative values as 0.

For ex: I have a list box of AMOUNT, which is having +ve & -ve values together. Now I want to replace all the -ve values with 0.

sunny_talwar — Wed, 16 Dec 2015 14:15:48 GMT

May be in the script:

If(AMOUNT < 0, 0, AMOUNT) as AMOUNT

Mark_Little — Wed, 16 Dec 2015 14:30:14 GMT

Hi,

In script as Sunny as suggested.

If you want to on list. use an expression (Same as what is above)

If(Amount < 0, 0, Amount)

Mark

mohan2391 — Fri, 18 Dec 2015 12:26:21 GMT

how to write this in set analysis

sunny_talwar — Fri, 18 Dec 2015 13:27:34 GMT

What is your expression currently?

Gysbert_Wassenaar — Sat, 19 Dec 2015 08:17:05 GMT

rangemax(Amount,0)