Add Option to Exclude NULLs in Measures for Bar Chart Objects

saharadi — Tue, 05 Aug 2025 12:03:45 GMT

Description:
In the Bar Chart object, Qlik Sense currently provides the ability to exclude NULL values in dimensions using the "Include NULL values" checkbox. However, there is no equivalent option for measures.

I would like to request a feature that allows users to easily exclude rows where the measure is NULL, similar to how it's done for dimensions. This would be especially helpful when working with calculated measures that may return NULL based on business logic, and where the goal is to only visualize valid (non-null) results.

Use Case:
When a measure returns NULL (e.g., due to division by zero, missing data, or conditional logic), the bar chart still reserves space for that bar, resulting in an empty gap. This can be misleading or visually unappealing in dashboards. An option to automatically hide or ignore such bars (just like with NULLs in dimensions) would improve both clarity and usability.

Re: Add Option to Exclude NULLs in Measures for Bar Chart Objects

stevedark — Wed, 06 Aug 2025 07:03:56 GMT

Hi @saharadi

In most cases you can do this by going to the Add-Ons option and desleect Include Zero Values:

Another way to do it is to exclude the values in the expression using set analysis, so in the simplest example to avoid zeros in an expression result you could have:

sum({<Value*={"<>0"}>}Value)

This will remove all values which are null or zero when doing the calculation. If no values exist for a dimension then that dimension won't show on the chart. However, if the value nets out to zero (so some positive and some negative values) then it would still give a zero result.

Hope that helps.

Steve

topic Re: Add Option to Exclude NULLs in Measures for Bar Chart Objects in Featured Members

Add Option to Exclude NULLs in Measures for Bar Chart Objects

Re: Add Option to Exclude NULLs in Measures for Bar Chart Objects