4 Replies Latest reply: Mar 18, 2012 3:14 AM by Sajeevan Govindan RSS

    Calculate percentage values in pivot table

    Simon Koenen

      Hi,

       

      I would like to calculate a percentage value within a pivot tabel.

       

      We have done this before by creating a variable containing the total value and used it as the divisor in the expression.

       

      But maybe there is a better way to do this.

       

       

      My Pivot Table should look similar to this one (right now only the exp1 columns are filled):

       

      MonthJan

      Feb

      KPIExp1Exp2%Exp1Exp2%
      KPI1106016,6666667209022,2222222
      KPI2206033,3333333309033,3333333
      KPI3306050409044,4444444
      Total6010090100

       

      How can I calculate the Exp2 and % columns in QlikView?

       

      I have tried to use this formular:

       

      =SUM([Values]) / SUM(Total [Values])

       

      But if I do so I will get the same values for all Exp2 columns and not with reference to the month dimension.

       

      That means if I make a "Total" all dimensions will be ignored.

       

      How can I ignore the KPI column on the first hand and reference to the month column on the other hand?

       

      Any suggestions?

       

      Thanks in advance

      Simon