Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi ,

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

Hope this will help you.

Highlighted
Specialist
Specialist

Hi,

     use the expression like this

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

regards,

Iyyappan

Highlighted

Hi,

     Try using this.

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

It won't consider null values.

Celambarasan

Highlighted
Champion
Champion

try this

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

may show red line but it will run

hope this helps

Highlighted
MVP & Luminary
MVP & Luminary

  

Hi,

Use this expression

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

Hope this helps you.

Regards,

Jagan.

Highlighted
Specialist
Specialist

Hi,

     cau u attach a sample file.

Iyyappan

Highlighted
Contributor
Contributor

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