QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Null values in visualizations

Data is sometimes missing or cannot be calculated, because the fields contain values that are null or not a number (NaN). In the visualizations, null and NaN values are displayed in different ways, according to the following table.

How Null and NaN values are displayed
Visualization type Null values in dimensions NaN values in measures
Bar chart – ( when labels are enabled in the properties panel, otherwise empty)
Box plot No representation
Combo chart A combination of the NaN value for the bar and the line.
Distribution plot No representation
Filter pane No representation N/A
Gauge N/A
Histogram No representation
Line chart Empty
Map No representation Gray
Pie chart Empty
Scatter plot Empty
Text & image N/A
Treemap Empty

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?