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



      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.





      Thank you in advanced


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