Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Does anyone have a solution?