Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
Values Dissapears After CrossTable
Article Number: 000005576 | Last Modified: 2015/02/09Description
During Cross Table load values appear to be removed from the data table. The missing value is part of the Cross Table qualifier field values.
This is related to NULL value in the Data Field.
Rows where all the data field values are equal to NULL will be removed during load.
In the example below the second row would diasappear.
| Sales team | 2010 | 2011 | 2012 |
|---|---|---|---|
| A | 1 | 1 | 1 |
| B | (null) | (null) | (null) |
| C | (null) | (null) | 1 |
Cause
QlikView interprets NULL values as non-existing values. Logically the value combination does not exist, and therefore it is not loaded. This is according to product design
Resolution
If the NULL values are intended as representation of blank values, they can be changed to empty strings during load. .
For example check if a field value is NULL and then replace with empty sting if the value is NULL.
if (isnull (2010), '',2010) as 2010
For example check if a field value is NULL and then replace with empty sting if the value is NULL.
if (isnull (2010), '',2010) as 2010
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.