Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenhasson
Creator
Creator

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
Partner - Creator III
Partner - Creator III

Good !!

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

View solution in original post

9 Replies
zhadrakas
Specialist II
Specialist II

you could use set Analysis Statement in your Expression

sample Expression:

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

stephenhasson
Creator
Creator
Author

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
Specialist II
Specialist II

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

consultant_bi
Creator
Creator

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
Partner - Creator III
Partner - Creator III

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
Creator
Creator
Author

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
Creator
Creator
Author

Thanks a lot for your help.

mohan_1105
Partner - Creator III
Partner - Creator III

Good !!

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

stephenhasson
Creator
Creator
Author

Great, thanks for your help