0 Replies Latest reply: Mar 16, 2012 6:36 AM by carolyn.miller RSS

    Using pivot cells in formulas?

    carolyn.miller

      Hi

       

      I want to create a simple variance cell in a pivot table showing the difference between active rates. I can easily do this in Excel but I'm finding this difficult in Qlikview. I'm a new user so sorry if I'm missing an easy soluition.

       

      Example table below:

       

      Good Claim StatusPoor Claim Status
      Time Lapse Element Active Active RateElement Active Active Rate% pt diff (poor vs. good)
      1 mth122,06596.1%14,72195.8%-0.29%
      2 mth119,84294.4%14,34793.4%-0.98%
      3 mth117,83192.8%14,01591.2%-1.56%

       

      Claim Status (include multiple categories) & Time Lapse are the Dimensions.

      The %pt diif (poor vs. good) is the field I'm trying to calculate.

       

      Thanks in advance

      Caz