Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a Field Index Within A Crosstab

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-1012241814.8%56905.27%12810813.7%
11-2015789919.1%1408513%17198418.4%
21-2812115714.7%1462313.5%13578014.5%
29-5527867833.7%4728943.8%32596734.9%
56-8012064314.6%2082319.3%14146615.1%
81+250583.03%54285.03%304863.26%
Total825853100%107938100%933791100%


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%

0 Replies