How to Filter rows in Table in Qlik Sense

[Midastouch365]

I want to write a function within a table that only filters based on the missing items. So for example, in the table below,  if Missing Items = '1', the item is missing. If Missing item = '0', then it's not missing.

How can I write the function to only disply Price and description in a table only if it has Missing Items = 1?

[stevejoyce]

In the table settings, Add-ons, uncheck Include zero values.  This will hide rows where all measures = 0. 

if you have other measures in your table they can all reference Missing Items, so it still does not show where Missing Items = 0 like If([Missing Items] > 0, expression2)

[DutchArjo]

sorry for answering/adding a question to this old question, but is there a way filter a whole table at once (without using the regular filters in Qlik) to limit the values shown in the table?

Let's say I have a 10 with 10 columns, And I want only to show the rows for this whole table where value in column 2 is equal to a hard coded value (so It doesnt change whenever a different selection is made somewhere in a filterobject).

[SunilChauhan]

use this in Script of Table

If([Missing Items]='1', 'Missing',If([Missing Items]='0', 'NotMissing') As NewcolumnName