Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stephenhasson
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
mohan_1105
Contributor III

Re: Conditionally exclude row from a table?

Good !!

Close the thread by marking the correct answer..!!

9 Replies
zhadrakas
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)

stephenhasson
Contributor

Re: Conditionally exclude row from a table?

Thank you for your reply.

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,

zhadrakas
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.

consultant_bi
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

Sans titre.png

Sans titre2.png

Sans titre3.png

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

mohan_1105
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"

stephenhasson
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.

stephenhasson
Contributor

Re: Conditionally exclude row from a table?

Thanks a lot for your help.

mohan_1105
Contributor III

Re: Conditionally exclude row from a table?

Good !!

Close the thread by marking the correct answer..!!

stephenhasson
Contributor

Re: Conditionally exclude row from a table?

Great, thanks for your help

Community Browser