# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Conditionally exclude row from a table?

Hi,

If I have

-Part Number

- Description

- Onhand-Qty

as columns in a table, how do I prevent rows where the 'Onhand-Qty' = 0 from being shown?

I've tried Aggr function, If statement etc, but can't figure it out.......

I can suppress the '0' and get '-' instead, but I can't get the rows to be excluded.

Thanks.

1 Solution

Accepted Solutions
Contributor III

## Re: Conditionally exclude row from a table?

Good !!

9 Replies
Valued Contributor

## Re: Conditionally exclude row from a table?

you could use set Analysis Statement in your Expression

sample Expression:

=Sum({\$<Onhand-Qty={0}>}TEST)

Contributor

## Re: Conditionally exclude row from a table?

Do you mean I should have this expression against the OnhandQty field's expression?

I've tried this:

=Sum({\$<OnhandQty={0}>}OnhandQty)

but it doesn't have any afffect.

Or do you  mean something else?

Thanks,

Valued Contributor

## Re: Conditionally exclude row from a table?

yeah that's right. If you have more Expressions you have to do it in every Expression to exlude this data.

Contributor

## Re: Conditionally exclude row from a table?

Hi,
you have to do it with a set analysis statement , here is below screenshots show you the formula to avoid zero values and result

as you can see i exclude the 0 value from the table.

Contributor III

## Re: Conditionally exclude row from a table?

Hi Stephen,

Just, select the table on right side, click on Add-ons and Unselect the "Include Zero Values"

and if you don't want to show the null values in the table which display as '-'

On right side, select your dimension and unselect "Include Null values"

Contributor

## Re: Conditionally exclude row from a table?

Thanks very much for your response... much easier than I'd though - i think I actually have some very very small qty that appear as 0 but aren't.

Thanks a lot.

Contributor

## Re: Conditionally exclude row from a table?

Thanks a lot for your help.

Contributor III

Good !!