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.
Name: Last, First
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.
Is Category a field in your database? If it is, then add category as a dimension (may be 1st dimension) and then you would see all the categories instead of just one. From what I understand, you may not need to use set analysis here.