Qlik Community

Qlik Sense Enterprise Ideas

Ideas for Qlik Sense Enterprise.

Display 0 in pivot table instead of - NULL

Partner
Partner

Display 0 in pivot table instead of - NULL

Hi all,

A great idea would be show a 0 or 0,00 instead of '-' (NULL value) for the rows (expressions) in a pivot table.

Thanks.

2 Comments
paarthsanghavi
New Contributor II

I think you can achieve this by changing the expression to if(isnull([Dimension / Measure]),  '0', [Dimension / Measure] ) 

Partner
Partner

Hi,

Please, this question has been discussed many times. That proposal doesn't work.

Thanks!