1 Reply Latest reply: Dec 20, 2016 2:51 AM by Peep Pallasma RSS

    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?