5 Replies Latest reply: Feb 17, 2013 1:13 PM by rksgsn001 RSS

    Calculate average, and add it as a row in load script

      Hello QlikView Community

       

      I have data as follows, residing in an Excel spreadsheet:

       

      ProjectPhase 1 Cost Phase 2 CostPhase 4 Cost
      A333

      B

      452
      C525
      D152

       

      In the LOAD script, I want to calculate the average of each Phase Cost, and have it appended to the end of the loaded data. To clarify, after the data has been loaded, I want the table to appear as follows:

       

      ProjectPhase 1 Cost Phase 2 CostPhase 4 Cost
      A333

      B

      452
      C525
      D15

      2

      Average3,253,753

       

      What should the script look like to calculate the average of each Phase?

       

      Thank you very much for reading