topic Re: How to use less than and = function in QlikView

How to use less than and = function

vikas_nandanwar — Fri, 15 Dec 2017 06:51:59 GMT

Hi,

Expression for less than and equal to function

I want a logical condition as

If Sum of Amount is less than zero then zero else sum of Amount

Column name as Amt

thanks

Vikas

tresB — Fri, 15 Dec 2017 06:53:45 GMT

RangeMax( Sum(Amt), 0)

If you want to understand using IF, try like:

If( Sum(Amt)<0, 0, Sum(Amt) )

If ( <condition>, what when true, what when false)

Anil_Babu_Samineni — Fri, 15 Dec 2017 06:54:30 GMT

If(Sum(Amount) < 0, 0, Sum(Amount))

vikas_nandanwar — Fri, 15 Dec 2017 07:00:13 GMT

Thanks This worked