@
Hello,
I am new to Qlikview development and I find myself stuck with a set analysis I am trying to make work. My hope is that someone can point me in the general direction that will help me complete the analysis.
The data I am using has ratings (excellent, satisfactory, and unsatisfactory) for five different categories for a class with 46 cadets. For instance, the table you see below does a count for only one category, PFT Ratings, for every cadet.
| PFT Ratings Name: Last, First | Excellent | Satisfactory | Unsatisfactory |
| Cadet A | 1 | 3 | 2 |
| Cadet B | 0 | 5 | 1 |
| Cadet C | 3 | 3 | 0 |
What I am trying to accomplish is a table showing a total count of ratings for all five categories. Once I have that I would like the customer to be able to roll down to find the sums for the individual categories.
Thank you!
