Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Q&A with Qlik! New Case Portal, Chat Bot and Qlik Community. Oct. 19th REGISTER TODAY

Qlik Sense Pivot table nodes disappear when some are expanded

Andrea_Bertazzo
Support
Support

Qlik Sense Pivot table nodes disappear when some are expanded

This problem occurs with Pivot tables, when the nodes are expanded as in a tree view. In some cases, it may happen that, when a specific node is expanded, the entire record (the list of nodes expanded) suddenly disappear and it is necessary to refresh the page to make it visible again.
This article explains why this happens.

 

Environment

 

Resolution

This is considered as the expected behavior when the expanded node has only null values and the “Include Null Values” is not flagged for a dimension in the record.
A possible solution is to flag that option for the dimensions involved in the Pivot table and in its expressions.

Cause

This  occurs when the latest expanded node contains only null values and  the dimensions it is based on is not set to show null values.  When this happens, the entire record associated with the null value has to be canceled up to the dimension level.
Notice that QlikView pivot tables work in a different way, so it is possible that the same table is not showing this behavior in QlikView.

Internal Investigation ID

QB-7503

Labels (2)
Version history
Revision #:
2 of 2
Last update:
Thursday
Updated by: