Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.

lubicz99
Specialist
Specialist

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
Specialist III
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.

lubicz99
Specialist
Specialist

Brittany,

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