topic Re: Hide a row in a straight table in App Development

Hide a row in a straight table

Markbhai — Wed, 22 May 2024 12:11:06 GMT

Is it possible to hide a row within a straight table?

I have a High Risk Table which currently shows all items but I want it only to show those which match a risk value.

Possible values are High, Low, and N/A

I want to hide all of the N/A ones.

Thanks

Mark.

theoat — Wed, 22 May 2024 12:25:02 GMT

Can you show us your table ?

rodrigo_martins — Wed, 22 May 2024 13:23:49 GMT

You could try something like that in your first dimension (assuming the field used is Dimension1):

if([Risk value]='N/A', null(), [Dimension1])

And remember to uncheck "Include null values"

Markbhai — Wed, 22 May 2024 14:56:54 GMT

My final expression was:

=IF([DPIA Status] <> 'N/A', [DPIA Status])

This rmoved the whole row once the 'Include Null Values' was un checked.

Thanks

Mark