Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cliff_clayman
New Contributor III

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?

Tags (1)
9 Replies

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

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

cliff_clayman
New Contributor III

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

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

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

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

cliff_clayman
New Contributor III

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

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

MVP
MVP

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

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
New Contributor III

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

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

MVP
MVP

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

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
Contributor

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

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.

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

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

Community Browser