Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot table Null value QlikSense

Not Approved32---1
Not Applicable21---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.

Labels (1)
1 Reply
Partner - Contributor III
Partner - Contributor III


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.

Regards, Igor.