topic Re: Hide straight Table rows with 0 in all expressions in QlikView

Hide straight Table rows with 0 in all expressions

AB108 — Thu, 28 Jul 2022 21:56:29 GMT

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

sidhiq91 — Fri, 29 Jul 2022 06:50:37 GMT

@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 — Fri, 29 Jul 2022 16:49:41 GMT

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.