Discussion board where members can get started with Qlik Sense.
If I have
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.
Go to Solution.
Close the thread by marking the correct answer..!!
you could use set Analysis Statement in your Expression
Thank you for your reply.
Do you mean I should have this expression against the OnhandQty field's expression?
I've tried this:
but it doesn't have any afffect.
Or do you mean something else?
yeah that's right. If you have more Expressions you have to do it in every Expression to exlude this data.
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.
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"
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.
Thanks a lot for your help.
Great, thanks for your help