Pivot table Null value QlikSense

[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.

[segador_]

Hi!

If the value 'Approved' in field "Compliance" does not have any associations with value 'CAT-1' in field "CAT" then Qlik Sense does not do any expression calculation with that couple values. Therefore, Qlik Sense will display nothing but the '-' character.

In QlikView, you can use the Null symbol representation option, but there is not the same option in Qlik Sense...

You can only add missing data (records to make associations between field "Compliance" and field "CAT") in the script.