# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP

## 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?

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.

MVP

## 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?

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

## 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?

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

## 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)

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.

MVP

## 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?