Creating An Index Field In A Crosstab

Sat, 14 Nov 2009 03:42:41 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?

Time Contacted Y Total N Pct N Total N Pct TOTAL PCT

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%

topic Creating An Index Field In A Crosstab in QlikView

Creating An Index Field In A Crosstab