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: 
Not applicable

Hiding row in straight table

Does anyone know how to hide this row? I tried using "suppress null values" and "suppress zero" values, but nothing happens. What expression can I write to substitute 0 with null value?

zerovalues.PNG

12 Replies
sunny_talwar

Have you tried 'Suppress When Value is Null' on the dimension tab?

Not applicable
Author

Yes, I've tried that.

Anonymous
Not applicable
Author

One of your expressions fields has data that does not have a corresponding value in your dimension.  You can choose to ignore these values by following Sunny's advice or you can try to clean up the data in your source table.

hemhund2016
Creator
Creator

can you post your QVW to fix the issue?

Not applicable
Author

You could try changing your expression to something like  If([Your Expression]=0, null(), [Your Expression]) and then checking the "suppress when value is null" option

miguelbraga
Partner - Specialist III
Partner - Specialist III

If your column is a field, then you could make a Where Clause in your script like this:

     WHERE [# Targeted POCs] <> 0;

Regards,

MB

Not applicable
Author

Which fields are expressions? and which are dimensions?

If all of them are dimensions you could create one field for expression and set not to show null values.

Giba

Not applicable
Author

DM is the dimension. The rest are expressions.

Anonymous
Not applicable
Author

Brittany,

Please share the expression you are using for # Targeted POC.