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

Pivot table Null value QlikSense

ComplianceCAT   
 TOTALCAT-1CAT-2CAT-3
TOTAL10343
Approved5---41
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
segador_
Partner - Contributor III
Partner - Contributor III

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.

Regards, Igor.