Pivot table Null value Handling when count function used

[srithottempudi]

Hi  Team,

Pivot table Null value Qlik Sense

Compliance	CAT
	TOTAL	CAT-1	CAT-2	CAT-3
TOTAL	10	3	4	3
Approved	5	---	4	1
Not Approved	3	2	---	1
Not Applicable	2	1	---	1

Above is a Pivot table  where 
1- Compliance is Dimension -(ROW)
2- CAT is Dimension-(Column)
3-Count of Compliance is the measure 

How can I eliminate the (--) for null and replace with ('0") Zero instead in my Pivot table.

Regards,

Srinivas

[srithottempudi]

Compliance	CAT
	TOTAL	CAT-1	CAT-2	CAT-3
TOTAL	10	3	4	3
Approved	5	---	4	1
Not Approved	3	2	---	1
Not Applicable	2	1	---	1

Above is a Pivot table  where 
1- Compliance is Dimension -(ROW)
2- CAT is Dimension-(Column)
3-Count of Compliance is the measure 

How can I eliminate the (--) for null and replace with ('0") Zero instead in my Pivot table.

Regards,

Srinivas

[Gysbert_Wassenaar]

You can't. That -- is most likely missing data instead of nulls. It does not exist and therefore can't be replaced. You will have to add that during the load for the missing combinations of Compliance and CAT.