Suggest an Idea

[carlos_pesquera]

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.

[UncleRiotous]

In the last couple of years of developing on Qlik Sense this is one of the things that keeps coming up again and again and again. We really need this functionality.

[Kayleigh_Milewski]

Also would love to change the color of the null cells

[vasilev]

To show null and missing values as 0 is very important visualization feature for our team. For is this a great limitation in Sense and it should be implemented with prio 1.

[davidhillier]

should be added asap. It's definitely necessary! 

[Rajashekar]

Yes. this should be added asap...

[how-is-it-possible]

Adding a simple feature to replace empty values with zeros seems like an obvious necessity. When combining data from different sources, it's inevitable to encounter missing values, similar to when using LEFT JOIN, and it would be beneficial to have the option to automatically convert those missing values to zeros. The explanation that this can be done at the load script level doesn't make sense, as it questions the purpose of having data merging capabilities at the visualization level altogether.

It is surprising that such a feature hasn't been implemented yet. Providing users with the ability to easily handle missing values and create visualizations accordingly would greatly enhance the flexibility and usability of Qlik Sense.

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.