Hide Rows if the Sum of Sales not available

[profilejamesbond]

Hi,

I have Product and Sum of Sales.

I have table in Qlik SaaS where I see the sales by products.
I have expression where I am showing sum of sales and where there is no sum of sales then there is hard coded text that I wrote "sales not available".

Now, I would like to hide the rows where I have text "sales not available". How to hide them from Table (Retired) in Qlik SaaS.

Thanks

[Jankiram]

Hi James,
"I’m a bit confused — why hardcode a value like 'Sales not available' and then try to hide those rows later?
If you simply want to exclude products with no sales, go to the Data Handling tab of the table and uncheck 'Include zero values' — this will hide all rows with null or zero sales dynamically.

[profilejamesbond]

Hi @Jankiram,

There are some values which are tagged in the same column with if else conditions such as sales < 0 should be marked as a 'Sales not available'.

There are multiple dimensions and exprssions in the same table therefore, Data Handling tab of the table and uncheck 'Include zero values' is not working.

Thanks

[Digvijay_Singh]

Not a good solution but probably you need to update all column measures to result into zero or null if this specific column expression is resulting into 'Sales not available'. This column as well can be set to show zero or null. Then you might be able to use property to uncheck 'include zero values.

[rafaelencinas]

Hi @profilejamesbond 

Can you share your expressions, prints  or QVF ?

In your scenario, 

1 - Users want to know if there are sales and where there aren't

2 - Remove zero values by unchecking.

Problably, you are trying to write sentenses in Measures

Bye!