topic Display Only Null Records in Straight Table Qlik sense in App Development

Display Only Null Records in Straight Table Qlik sense

UserID2626 — Tue, 15 Mar 2022 10:37:50 GMT

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

Re: Display Only Null Records in Straight Table Qlik sense

Or — Tue, 15 Mar 2022 10:46:56 GMT

With "Include zero values" unchecked in your table:

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

Re: Display Only Null Records in Straight Table Qlik sense

UserID2626 — Tue, 15 Mar 2022 10:51:43 GMT

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

Re: Display Only Null Records in Straight Table Qlik sense

Or — Tue, 15 Mar 2022 10:56:11 GMT

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?