Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Display 0 in pivot table instead of - NULL

carlos_pesquera
Partner - Contributor II
Partner - Contributor II

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.

19 Comments
UncleRiotous
Creator
Creator

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
Contributor III
Contributor III

Also would love to change the color of the null cells

Patric_Nordstrom
Employee
Employee
 
Status changed to: Open - On Roadmap
vasilev
Contributor III
Contributor III

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
Contributor
Contributor

should be added asap. It's definitely necessary! 

Rajashekar
Contributor III
Contributor III

Yes. this should be added asap...

how-is-it-possible
Contributor
Contributor

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived