topic Re: Help with an expression in QlikView

Help with an expression

Thu, 26 Feb 2015 18:28:13 GMT

Hello

I have two expression columns in my report

1. sum[Book Amount]

2. sum([Sale Amount])

I want to write a condition in my first expression where if sum([Sale Amount]) is 0 then make sum([Book Amount]) as 0 so that I can suppress that rows by suppress zero values aand if its not 0 then give me the sale Amount.

Thanks

Re: Help with an expression

Anonymous — Thu, 26 Feb 2015 18:32:21 GMT

Exactly as you say:

if(sum([Sale Amount])=0, 0, sum([Book Amount]))

Re: Help with an expression

Thu, 26 Feb 2015 18:47:01 GMT

Exactly as you say:

Sum(If(sum([Sale Amount]) = 0,[Book Amount)]

Re: Help with an expression

anbu1984 — Fri, 27 Feb 2015 05:33:06 GMT

=if(sum([Sale Amount]), sum([Book Amount]))

Re: Help with an expression

mohammadkhatimi — Fri, 27 Feb 2015 05:37:06 GMT

Hie Rizwan ,

Try this

if(sum([Sale Amount])=0, 0, sum([Book Amount]))

Regards,

Mohammad

Re: Help with an expression

CELAMBARASAN — Fri, 27 Feb 2015 05:53:07 GMT

Try this

Sum([Book Amount]) * RangeMin(1, Fabs(Sum([Sale Amount])))

Re: Help with an expression

praveenak — Tue, 03 Mar 2015 10:23:33 GMT

Can i ask for a sample qvw of your requirement? so that i can understand your basic requirement...

Coz I think the request u gave will base on the dependency of Sale Amount and Book Amount in some of my approaches.

If nothing like that dependency present, i suppose it can done with small scripts or QV in-built options.