Filter straight table with expression results

[#1]

Hi!

I am very new to QV:) I have a straight table with 3 dimensions and 2 expressions. I wanted to filter out the rows in where both expression1 and expression2 have null or zero values.

Do you know how can I do it?

Trying to find a workaround, I tried to create an additional expression to flag the rows in where both expressions are null or zero. It does flag the rows, but I do not know how to filter out based on this expression result.

Thanks!!!!

[Digvijay_Singh]

Hi,

Did you try 'Suppress when value is Null' in Dimension tab and Suppress zero values in expression tab?

Thanks,

Digvijay

[Digvijay_Singh]

Please share always sample data and app for faster response from community.

[gautik92]

in dimension tab you will be have supress when null option use it

[jonathandienst]

Remove your flag expression and make sure ' Suppress zero values' is checked in the expression tab.

[#6]

I had already checked the "Suppress zero values" in the expression tab. Rows will still show because the dimensions displayed in the table are not null.

The straight table has 3 dimensions and 2 expressions.What I would like to do is to not display the dimension rows in case two of the expressions are both null. Is it possible to not display dimensions depending on the value of an expression??

Thank you!

[Digvijay_Singh · Accepted solution]

It shouldn't show dimension if values are null, check if you have activated this in dimension tab -

[#8]

Thanks