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 Status
Poor Claim Status
Time Lapse
Element Active
Active Rate
Element Active
Active Rate
%pt diff (poor vs. good)
1 mth
122,065
96.1%
14,721
95.8%
-0.29%
2 mth
119,842
94.4%
14,347
93.4%
-0.98%
3 mth
117,831
92.8%
14,015
91.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.
