topic Creating A Index In Crosstab in QlikView https://community.qlik.com/t5/QlikView/Creating-A-Index-In-Crosstab/m-p/151763#M29463 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-599_sourceID:599" /></P></BODY></HTML> Sat, 14 Nov 2009 03:32:08 GMT 2009-11-14T03:32:08Z Creating A Index In Crosstab https://community.qlik.com/t5/QlikView/Creating-A-Index-In-Crosstab/m-p/151763#M29463 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-599_sourceID:599" /></P></BODY></HTML> Sat, 14 Nov 2009 03:32:08 GMT https://community.qlik.com/t5/QlikView/Creating-A-Index-In-Crosstab/m-p/151763#M29463 2009-11-14T03:32:08Z