Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AB108
Contributor III
Contributor III

Hide straight Table rows with 0 in all expressions

Hi ,

I have a straight table with about 11 dimensions and 15 expressions(long complicated codes).

I want to hide all the values which have zero in the expression.

I have checked the suppress zero options in the Chart properties.

I also have about 3 expressions that are blanks and added for visualizations.

What is the best way to achieve this.

 

Thanks

 

 

Labels (2)
2 Replies
sidhiq91
Specialist II
Specialist II

@AB108 Not sure if we have suppressing zeroes option in the straight table, I am aware it is available in the chart though.

Also, what we need to keep in mind is if one expression is yielding zeroes as the output then what about other expressions?

AB108
Contributor III
Contributor III
Author

Hi,

The option to suppress zero is present in the properties for Straight table.

For certain rows all the expressions evaluate to zero. Those are the rows I want to hide.