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