Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense Pivot Table Functions Can't Handle Missing Data

On QlikView I can create a computed measure in a pivotal table by doing:

if(isNull(before(myMeasure, 0)), 0, before(myMeasure, 0))

This converts all missing values to some default of my choosing (0 in this case)

This is very helpful when data is sparsely populated for some row/column combination.

Unfortunately, the same formula does not work in Qlik Sense: A cell with a missing value remains missing.

Is this a bug in Qlik Sense's handling of missing data in Pivot Table charts?

Is there a work around?

1 Reply
Not applicable
Author

Does anyone have a solution?