Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

NULL value in chart dimension

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ToniKautto
Employee
Employee

NULL value in chart dimension

Last Update:

May 10, 2022 3:25:39 PM

Updated By:

Jamie_Gregory

Created date:

Jun 10, 2014 2:07:26 AM

Chart object can get an unexpected NULL value in the dimension, even though there is no Null value in the loaded data. 

Visualisation of a chart showing a NULL dimension.png

The loaded data does not contain Null values. The expected result is that the chart reflects the loaded data. 

Visualisation of the data not conatining NULL data.png

 

Environment:

QlikView 
Qlik Sense Enterprise on Windows 
Qlik Sense Business 
Qlik Cloud 

 

The NULL value can be visualized by disabling or unchecking any suppression of Null or Missing values. 

  • Chart Properties > Dimensions > Settings for Selected Dimension > Suppress When Value Is Null
  • Chart Properties > Presentation > Suppress Zero-Values
  • Chart Properties > Presentation > Suppress Missing

 

The data model reveals that there is a connection from the data table over which the chart is calculated. In this case the Store table has a link to the Fruits table. 

Visualisation of a data model.png

The key field details in the Store table show that only a 25% of the values in Fruit are used in the Store table. 

Visualisation of a data model showing key information.png

The data used for the chart calculation will include also a representation of the unused key field values. The chart calculation is based on data that looks like the below image. When the key field is removed there is still a Null representation in the Sales and SalesPerson field as an indication of the subset ratio, as highlighted in within the red square. 

Visualisation of a chart showing a NULL dimension and more information.png

The data set used for the chart calculation will therefore have a Null value in the SalesPerson field, and if expanded in the chart the Null value can be seen. 

Resolution:


There are two main approaches to visually remove the Null value from the chart.

  1. In a chart object the Null value dimension can be suppressing Missing values.
    Chart Properties > Presentation > Suppress Missing
     
  2. Generate a data model where there is a 100% subset ratio within the data that is calculated. 
Labels (2)
Version history
Last update:
‎2022-05-10 03:25 PM
Updated by: