topic Remove zero valued rows from Straight Table in QlikView

Remove zero valued rows from Straight Table

Wed, 16 May 2012 12:47:24 GMT

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

swuehl — Wed, 16 May 2012 13:20:27 GMT

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

Thu, 17 May 2012 11:36:49 GMT

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

Thu, 17 May 2012 12:29:36 GMT

Hi,

You can also create a calculated dimension as

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

Regards

Ankur

Thu, 17 May 2012 12:43:47 GMT

use this expression

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