11 Replies Latest reply: Jun 22, 2017 7:41 AM by Sunny Talwar RSS

    CALCULATED FIELD IN PIVOT

    Ritesh Tiwari

      Hi,

       

      I am fairly new to Qlikview and am looking for your help in fixing a challenge with pivot table. I have created a pivot table in one of my reports and now I need to create a calculated field.  Sample -

         

      COUNTRYPROMOTERSDETRACTORSPASSIVES
      CHINA200220202038
      AUSTRALIA203620542072
      UK207020882106
      USA210421222140

       

       

      Where Promoter, Detractors & Passives are values of one of the fields. What I essentially need is to create a new calculated column that should be  (Promoter - Detractors) / Sum(Promoter, Detractors & Passives).

       

      Any help will be really appreciated.

       

      Thanks,

      Ritesh