Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove zero valued rows from Straight Table

Hello,

I've been trying to remove zero valued rows from Straight Table, file attached, rows coloured in Red but unable to do so.

The format of the sum(Sales) & sum(Others) is Decimal Precision=2

Search in other discussions hasn't helped.

Any help

Regards

1 Solution

Accepted Solutions
swuehl
MVP
MVP

The supress zero values option in presentation tab will only work as expected if all expressions return zero.

I understood that you want to suppress based on sum(Sales) (see for example row 2490).

So you can first change your first expression to

=if(fabs(sum(Sales) )>=0.01,sum(Sales),0)

to force QV to consider very small values as zero values.

Then your second expression could look like

=if(column(1),sum(Other),0)

and the last expression like

=if(column(1),column(1)/column(2),0)

Check suppress zero values in presentation tab.

Hope this helps,

Stefan

View solution in original post

4 Replies
swuehl
MVP
MVP

The supress zero values option in presentation tab will only work as expected if all expressions return zero.

I understood that you want to suppress based on sum(Sales) (see for example row 2490).

So you can first change your first expression to

=if(fabs(sum(Sales) )>=0.01,sum(Sales),0)

to force QV to consider very small values as zero values.

Then your second expression could look like

=if(column(1),sum(Other),0)

and the last expression like

=if(column(1),column(1)/column(2),0)

Check suppress zero values in presentation tab.

Hope this helps,

Stefan

Not applicable
Author

Hi,

It helped tremendously

the best thing to know is :

The supress zero values option in presentation tab will only work as expected if all expressions return zero."

very informative indeed

Many Thanks

Regards

Not applicable
Author

Hi,

You can also create a calculated dimension as

=if(fabs(sum(Sales) )>=0.01,Dim)

Regards

Ankur

Not applicable
Author

use this expression

if(fabs(aggr(sum(Sales),Dim))>=0.01,Dim)