5 Replies Latest reply: Oct 27, 2016 5:55 AM by Sunny Talwar RSS

    Expression to calculate sum of a column in pivot table

    Apoorva SD

      Hi all,

       

      I have a requirement as follows:

       

      I have a pivot table with one dimension say, "Plant Name" and one expression which is "Expression1" with values as shown below. Now i need to have one more expression in my pivot table which has the following condition: Say for example, for "Plant Name" A, "Expression2" should be: value in "Expression1" (i.e. 20) divided by sum of the values in column "Expression1" (i.e. 60 in our case here) multiplied by 100.

       

      Plant NameExpression1Expression2
      A20(20/60)*100
      B10(10/60)*100
      C30(30/60)*100

       

      Is it possible to achieve this in QlikView?

       

      Any suggestions?

       

      Thank you.