Missing value symbol not applied on missing values in chart object

000005548 |18/04/2017
Did this article help solve your issue?

   

Description

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

 

Cause

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. 

Resolution

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. 

Disclaimer

Access to this article is provided to you as part of your subscription to Qlik Maintenance. This article is deemed to be “Documentation” under the terms of the license agreement applicable to your Qlik software. All rights reserved © QlikTech International AB.

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