6 Replies Latest reply: Sep 13, 2017 11:56 AM by Santiago S?nchez RSS

    Handling missing values in Average total mode pivot table

    Santiago S?nchez

      Hi,

       

      Im trying to perform an average in a pivot table. Mi problem is that i can´t get de correct result in totals because there are not registers for all the months. The first employee only has data for Jun so the total doesnt count July and Ago. I know it´s working ok in Qlik, but i need  Qlik thinks there are 0s  in these months.  So the result for the first row must be 0,51.

       

      Example:

       

      Example.PNG

      Thank you in advanced

       

      My expression  is 'sum({<ConceptoNCod={'940'}>}KPI03)/Count(DISTINCT MesAño)'