How to build a table that can take data from multiple columns and then calculate ... (for details refer below)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have data set with approx. 100 columns.

Out of these 100 columns I need to build a table with 5 columns. The table that i need will look like below

To further elaborate :

1. Dead air, Hold procedure ... etc are different columns in the database. For each of these column record entry can either be "NO" or "YES"

What i want is one table that should

1. show all these column name one below the other (as in the figure)

2. should first calculate the count of "NO" for each one of them

3. should count the total of "NO+YES" for each of them

4. should then calculate cumulative distribution, i.e. count of no / total sum of count of no

5. should calculate compliance of each item, i.e for example for dead air 11/120 or total errors /total opportunities.

For your ease i am attaching the data dump & relevant QV file also

NOTE: this database has multiple columns. All i need is if someone can help me design this using 2 or 3 columns. Rest i can do myself.

Column Name	Count of "NO"	Total Opportunities	Frequency distribution	Compliance
Calculation	(Count of "NO") of each of these columns		Count of "No" for each field / Sum of "No" for all the fields	Count of NO/Total opportunities
Dead air	11	120	2.79%	91%
Hold procedure	1	120	0.25%	99%
Addressing the customer	1	120	0.25%	99%
Opening	7	120	1.78%	94%
Timely opening	1	120	0.25%	99%

topic How to build a table that can take data from multiple columns and then calculate ... (for details refer below) in QlikView