Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Show only those values in a table which are NULL

Hi All,

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

values.png

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.

4 Replies
Highlighted
Partner
Partner

Re: Show only those values in a table which are NULL

Hello Simran,

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

null_05.PNG

BR,

Maria

Highlighted
Contributor II
Contributor II

Re: Show only those values in a table which are NULL

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.

Highlighted
Champion III
Champion III

Re: Show only those values in a table which are NULL

try this

May be a calculated Dimension:

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

Highlighted
Partner
Partner

Re: Show only those values in a table which are NULL

Hi,

Add Calculation Dimension for Column B  like below.

=if(isnull(B),B)