Pivot Null to Zero

[vpanchuda]

Pivot table Null value QlikSense

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.

[vpanchuda]

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.

[sunilkumarqv]

please try

Replace(Measure,'---','0')