3 Replies Latest reply: Feb 2, 2017 11:11 AM by Jennifer Heatly RSS

    Set Analysis Help

    Jennifer Heatly

      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!