Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

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.