Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cgT
Creator
Creator

Hide Table Rows that have zero values in all columns

Hi everyone,

I'm trying to exclude any results in my table that have zeroes across all columns/measures.

The first thing I tried was to untick 'Include null values' in the dimension options.

Is anyone able to guide me in the right direction?

Thanks

Labels (2)
1 Solution

Accepted Solutions
cgT
Creator
Creator
Author

I had tried this too but thanks for the reply.

I have found that a measure at the end of the table columns had a value in it, once I deleted that column it worked.

 

Many thanks.

View solution in original post

2 Replies
Lakshmanan
Partner - Contributor III
Partner - Contributor III

Under Add-Ons - > Data Handling ->Uncheck "Include Zero Values".

 

Please mark as resolved if it solved the issue.

cgT
Creator
Creator
Author

I had tried this too but thanks for the reply.

I have found that a measure at the end of the table columns had a value in it, once I deleted that column it worked.

 

Many thanks.