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

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

cliff_clayman — Tue, 11 Oct 2016 20:37:39 GMT

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?

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

sunny_talwar — Tue, 11 Oct 2016 20:39:00 GMT

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

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

cliff_clayman — Tue, 11 Oct 2016 20:40:03 GMT

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

sunny_talwar — Tue, 11 Oct 2016 20:41:11 GMT

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

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

cliff_clayman — Tue, 11 Oct 2016 21:12:02 GMT

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

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

swuehl — Tue, 11 Oct 2016 21:25:52 GMT

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?

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

cliff_clayman — Tue, 11 Oct 2016 21:29:46 GMT

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

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

swuehl — Tue, 11 Oct 2016 21:47:18 GMT

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)

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

shawn-qv — Tue, 11 Oct 2016 22:44:20 GMT

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.

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

sunny_talwar — Tue, 11 Oct 2016 22:53:41 GMT

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