topic error in sum in QlikView

error in sum

alec1982 — Wed, 08 Aug 2012 16:23:58 GMT

Hi,

I have a text box to sum a field based on filters of other fields as follow

=Sum(

if ((([Year] = 2012)

and (PLS = 1)

)

, [Amount (USD-annual)]

)

It is giving me value = -

I know that if i comment PLS=1 I get the Nrs, so the error is in this field.

the field has values as follow

PLS

Anybody can help Please..

Thanks,

Alec

swuehl — Wed, 08 Aug 2012 16:29:19 GMT

Are you sure that you have any values in field Amount for the combination of Year = 2012 and PLS =1?

Create three list boxes for Amount, Year and PLS, then select 2012 in Year.

Check if PLS = 1 is a possible value.

If yes, select 1 in field list box PLS and check if you've got any values in field Amount.

alec1982 — Wed, 08 Aug 2012 16:43:23 GMT

Thanks for the replay,

yes. I do have values.

I created a table box and I see the values.

Thxs,

alec1982 — Wed, 08 Aug 2012 16:53:06 GMT

I guess that I have figured this one out.

Thxs,