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
Knowledge
Set Analysis Calculation Showing Incorrect Values in Pivot Table.
Article Number: 000075068 | Last Modified: 2019/05/20Description
It was reported that expressions using set analysis in a pivot table were not showing expected/correct results in a pivot table. The calculated values were different than what was expected.
Environment: QlikView 12.20
Environment: QlikView 12.20
Cause
The root cause of this issue was related to problems in the data model. synthetic keys, missing data from columns and missing columns which were not created in the related tables.
Resolution
Some of the nulls shown in a pivot table do not occur from null values in fields, but occur from missing rows from related tables, based on the data model. In this situation, there were some synthetic keys, some columns were missing values and some expected columns were not present in all the tables. The NullAsValue function was used to populate some of the missing data in some columns.
It was found that some of the tables were actually missing columns that should have been included. These columns were added and populated with non-null values and after these efforts to clean up the data model, the issues were resolved and the calculations had the correct expected values.
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. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us