Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
SerSwagster
Creator
Creator

Show only null value in a straight table

Hi everyone. I have a straight table with several dimensions. I want to show the rows having for a specific dimension null values. I can't do this with a separate filter table because null occurrence is not shown in the filter.

For example, I want a table like this (to select all the free agent players):

Player        Role        isNull(Team)

Thanks in advance.

1 Solution

Accepted Solutions
rubenmarin

Hi, you can have a table with Player as dimension, and another calculated dimensionlike:

=Aggr(If(Count(Team)=0,Role),Player,Role)

Uncheking the option to show null values

Or add a table With Player and role as dimensions and an expression like: If(Count(Team)=0,'No Team')

View solution in original post

1 Reply
rubenmarin

Hi, you can have a table with Player as dimension, and another calculated dimensionlike:

=Aggr(If(Count(Team)=0,Role),Player,Role)

Uncheking the option to show null values

Or add a table With Player and role as dimensions and an expression like: If(Count(Team)=0,'No Team')