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: 
cliff_clayman
Creator II
Creator II

How to filter out zero dollar values in a Sum using Set Analysis

I have a set analysis expression that calculates the Sum of the value Amount:

=Sum({$<[FY]={$(vFY)}, [Division]={'A','B','C','D','E','F'}>} [Amount])

I do not want to see the values that are equal to $0.00  How can I filter those out?

9 Replies
sunny_talwar

May be check 'Suppress zero values' on the presentation tab of your chart properties?

cliff_clayman
Creator II
Creator II
Author

This is in a straight table and I do have Suppress Zero-Values checked.

sunny_talwar

Could the value be very small like 0.00000000012 or something like that?

cliff_clayman
Creator II
Creator II
Author

I suppose that is possible, but I don't think so.

swuehl
MVP
MVP

Not sure I understand your issue.

Could you post some more details (chart dimensions, other expressions, a screenshot etc)?

Or could you post a small sample QVW?

cliff_clayman
Creator II
Creator II
Author

I have data in a straight table.  I do not want to see the Sums that equal $0.00

=Sum({$<[FY]={$(vFY)}, [Division]={'A','B','C','D','E','F'}>} [Amount])

Division     Period     FY     BU     Amount

A               11          16     123     $100,000

A               11          16     345     $200,000

B               11          16     678     $0.00

B               11          16     901     $500,000

C               11          16     123     $0.00

C               11          16     345     $450,000

swuehl
MVP
MVP

Amount is your only expression?

And 'Suppress zero values' is enabled on presentation tab?

And Amount field values are integer values?

(you could also try for now using

=Round( Sum( ... Amount))

, if this makes any difference)

shawn-qv
Creator
Creator

Cliff, can you share a sample QVW showing this behaviour, as your expression together with the "suppress zero values" option works as expected when I try to replicate your issue.

S.

sunny_talwar

Would be difficult to know what is wrong unless we see the issue. Would you be able to share screenshots at least?