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 Dhulehole

      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


      Is it possible to achieve this in QlikView?


      Any suggestions?


      Thank you.