Qlik Support

Missing value symbol not applied on missing values in chart object

000005548 |17/01/2019
Was this content helpful?


The following data is loaded into QlikView, which results in the F1 value B not having any associated value in field F2. 

User-added image

In a straight table object the F2 value for B is NULL and not MISSING as expected.

User-added image



Before calculating the straight table object, a JOIN operation is performed in memory to generate the data set over which the straight table is calculated. In the same way as with JOIN operations during application reload, missing values are populated with NULL. For this reason the missing values are never seen in a straight table.

Pivot table is the only chart object that will display missing values with the missing symbol, but only when it is pivoted in a way that missing data combinations occur. 


Due to the technique used to create the in memory data set, there is currently no way to accomplish missing values symbol in straight tables. 

Use the quick links or the search bar on the front page for quick answers.

Selecting one or several business profiles ensures you get the most valid information presented to you.

A new self-service feature enables you to download a LEF or Request a control number with the click of a button.

A completely new element! Create and manage your Qlik environments for a great overview and to ease the case submission process. Add in your licenses and products and have a full view of your own environment setup.

Add stakeholders who should receive updates to the case. See the latest status of your case and if any actions are needed.

Submit your cases to us with ease using the new case logging wizard.

We would really appreciate your feedback which would help us improve the experience on the Support Portal. Please email us on SupportPortal@qlik.com