Show only those values in a table which are NULL

[simran04]

Hi All,

I have a straight table with two columns: A and B with the following values.

I want to show only those values of column A which have only NULL values of Column B.

For e.g., for column A =60 and 63, Column B is NULL and NON-NULL. So, in this case I want to show all values of Column A except 60 and 63.

Thanks.

[JaMajka1]

Hello Simran,

you can use filter on the column A '=isnull(B)' as radoresky‌ mentioned in one of his posts .

BR,

Maria

[simran04]

Hi Maria,

I want to show only those values in the table which are only NULL.

I don't want to show the NON NULL values.

Thanks.

[Chanty4u]

try this

May be a calculated Dimension:

If(Len(Trim([YourField])) = 0, 'Null', Null())

[Anonymous]

Hi,

Add Calculation Dimension for Column B  like below.

=if(isnull(B),B)