Creating a Field Index Within A Crosstab

Sat, 14 Nov 2009 03:40:10 GMT

I have a crosstab table that displays the 'Total Times Contacted' bands down the side and a 'Do Not Contact' Y/N flag across the top. Within the crosstab is both a count of records within each grouping, along with a percentage of that field to the total (see below). What I want to be able to do is divide, by band, the 'Y' percentage value by the 'N' percentage value, and then take that number x 100 to get the index between the fields. Is this possible?

DNC Flag Y N TOTAL

Time Contacted Total Pct Total Pct TOTAL PCT

1-10 22,418 14.8% 5,690 5.27% 128,808 13.7%

11-20 157,899 19.1% 14,085 13.0% 171,984 18.4%

1-10	122418	14.8%	5690	5.27%	128108	13.7%
11-20	157899	19.1%	14085	13%	171984	18.4%
21-28	121157	14.7%	14623	13.5%	135780	14.5%
29-55	278678	33.7%	47289	43.8%	325967	34.9%
56-80	120643	14.6%	20823	19.3%	141466	15.1%
81+	25058	3.03%	5428	5.03%	30486	3.26%
Total	825853	100%	107938	100%	933791	100%

21-28 121,157 14.7% 14,623 13.5% 135,780 14.5%

ETC...

........... .............. ............ ............ ............. ................ ..............

TOTAL 825,853 100% 107,938 100% 933,791 100%

topic Creating a Field Index Within A Crosstab in QlikView

Creating a Field Index Within A Crosstab