6 Replies Latest reply: Jul 2, 2011 11:49 AM by Johan Vermeulen RSS

    Totals problem in expression. Expression total versus sum of rows

    Johan Vermeulen

      Hi,

       

      I'm calculation values in a expression column. In another column the result is alted by an IF function.

      On total level this IF function does not work correctly. It should use the total headers of the expressions, not the line values.

      I tried the option 'sum of rows' and expression totals, the results are different but not correct.

       

       

      HOW IT SHOULD BE:

      CustomerProductMaintenance 2009Maintenance 2010Retented SalesRetention rate
      AX100000%
      AY200270200100%
      AZ100808080%
      TOTAL A.40035028070%
      BX2010020100%
      BY20012012060%
      TOTAL B.22022014064%

       

      How Qlikview does it

      CustomerProductMaintenance 2009Maintenance 2010Retented SalesRetention rate
      AX100000%
      AY200270200100%
      AZ100808080%
      TOTAL A.400350280180%USING SUM OF ROWS
      BX2010020100%
      BY20012012060%
      TOTAL B.220220140100%USING EXPRESSION TOTAL

       

       

      Retented sales: Sales which have occurred in 2010 as a follow up on 2009. No new sales

       

      Please check enclosed excel file for the formulas of the example

       

      Hope you can help me.

       

      Kind regards,

      Johan Vermeulen

      K3 Business Solutions.