Hide rows in straight table based on field value

[matthewp]

I have a straight table that I want to hide the rows unless the Flag field is null.

The values in the Flag field can be A, B or NULL ( - ).

How can i do this

[HirisH_V7]

You can suppress null() for the particular dimension,

or at presentation tab, -> supress missing or supress zero for your particular columns need to be ticked.

-Hirish

[matthewp]

I DONT want to suppress null, i want to ONLY show null

[tamilarasu]

Hello Matthew,

Add below expression in your expression tab.

If(Len(Trim(Flag Field Name))=0,'-',0)

And make sure "Suppress Zero-Values" option is enaled in the presentation tab.

[matthewp]

I DONT want to suppress nulls, i want to ONLY show nulls

[tamilarasu]

The above expression will shows the null values and hides remaining values. Have you tried the expression?

[matthewp]

Yeh it still doesnt show them

[Anonymous]

Hi,

Please see attached.

Hope it helps!

[tamilarasu]

The expression is working fine in the below attached file.