Display Only Null Records in Straight Table Qlik sense

[UserID2626]

Hi,

I want to show only null records in my straight table.

Consider below table is my input

DIM_1	DIM_2	KPI
A	Product1	5
A	Product2	64
B	Product1	32
C	Product1	1
B	Product2	6
-	Product1	23
E	Product1	54
A	Product5	23
C	Product4	543
-	Product6	24
B	Product66	234

My Output will be

DIM_1	DIM_2	KPI
-	Product1	23
-	Product6	24

How to write the dimension condition for this.

Thanks

[Or]

With "Include zero values" unchecked in your table:

Sum(if(isnull(DIM_1),KPI))

[UserID2626]

Thanks for the Quick Reply Or.

Can you help me with Dimension condition. I have another chart where the no KPI, But Need to show null records

[Or]

I'm not sure what exactly you're trying to achieve with this second requirement. A chart with a null dimension and a null measure seems like it wouldn't be very helpful?