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 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.
Thanks in advance
Caz