2 Replies Latest reply: Oct 25, 2012 6:11 PM by Rob Uselman RSS

    How do I use an expression column total in Row calculation

    Rob Uselman

      I am new to Qlik view so this question may be basic but I have not found anything that works

       

      I have created a Straight table that has

      Demension A, B, C and

      Expressions D, E, F

       

      What I need to do is use the Average of all values in column F as part of a calculation to create new column G..

      If I were doing this in a spreadsheet Cell G2 it would look like this:  "=D2 - SUM(F:F)", Cell G3 would be "=D3 - SUM(F:F)", etc

       

      Any help is appreciated