Using pivot cells in formulas?

Fri, 16 Mar 2012 10:36:26 GMT

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

topic Using pivot cells in formulas? in QlikView

Using pivot cells in formulas?