topic Re: How to sum(amount) except null? in QlikView

How to sum(amount) except null?

Tue, 28 Feb 2012 08:13:31 GMT

I have data sample below:

Region	Amount
Region A	5000
Region B	4000
	3000

I want to sum up all amount excluding the Region which is NULL or no region. Now, this is simple when manipulating the table properties. But this time, I want to sum it up through set analysis... So is it possible to sum(amount) except Null Region?

This is my idea, something like this: sum({<Region is not Null>} Amount)

Please help me get over this, thanks. Coz I want it to display in the dashboard, and displaying data in the dashboad includes null values. Which is DUH!

Thanks.

Best Regards,

Bill

How to sum(amount) except null?

vijay_iitkgp — Tue, 28 Feb 2012 08:22:07 GMT

Hi ,

You can use Sum(Amount) only and Go to Properties--->Dimension and check Supress when value is null.

Hope this will help you.

How to sum(amount) except null?

v_iyyappan — Tue, 28 Feb 2012 08:22:21 GMT

Hi,

use the expression like this

=if(IsNull( Region),sum( Amount))

regards,

Iyyappan

How to sum(amount) except null?

CELAMBARASAN — Tue, 28 Feb 2012 08:38:43 GMT

Hi,

Try using this.

=sum({<Region={'*'}>} Amount)

It won't consider null values.

Celambarasan

How to sum(amount) except null?

SunilChauhan — Tue, 28 Feb 2012 08:47:08 GMT

try this

sum({<Region-={}>} Amount)

may show red line but it will run

hope this helps

How to sum(amount) except null?

jagan — Tue, 28 Feb 2012 08:48:05 GMT

Hi,

Use this expression

=Sum(If(Not IsNull(Region), Amount))

Hope this helps you.

Regards,

Jagan.

How to sum(amount) except null?

v_iyyappan — Tue, 28 Feb 2012 09:48:36 GMT

Hi,

cau u attach a sample file.

Iyyappan

Re: How to sum(amount) except null?

cavmih18 — Wed, 18 Sep 2019 13:08:58 GMT

This helped me with a similar problem. Thanks. Well appreciated.