Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sum(amount) except null?

I have data sample below:

Region
Amount
Region A5000
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

7 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi ,

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

Hope this will help you.

v_iyyappan
Specialist
Specialist

Hi,

     use the expression like this

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

regards,

Iyyappan

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try using this.

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

It won't consider null values.

Celambarasan

SunilChauhan
Champion
Champion

try this

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

may show red line but it will run

hope this helps

Sunil Chauhan
jagan
Luminary Alumni
Luminary Alumni

  

Hi,

Use this expression

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

Hope this helps you.

Regards,

Jagan.

v_iyyappan
Specialist
Specialist

Hi,

     cau u attach a sample file.

Iyyappan

cavmih18
Contributor
Contributor

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