topic Calculate -Ve values in QlikView

Calculate -Ve values

Mon, 29 Dec 2014 10:09:15 GMT

Hi all ,

What to do if want to calculate on only negative values,

Ex : Arrears

-10000

20000

-500

3000

-4500

i want to calculate only -Ve valuescan any one help.

Thanks

amit_saini — Mon, 29 Dec 2014 10:10:46 GMT

Hi,

Can do like this:

if(Sum(Field) < 0, Sum(Field))

Thanks,
AS

Mon, 29 Dec 2014 10:10:54 GMT

sum(if(Arrears<0,Arrears))

Mon, 29 Dec 2014 10:26:31 GMT

Thank you Venkat Reddy.