4 Replies Latest reply: Jul 24, 2012 11:16 AM by Jason Zola RSS

    Easy Question on Counting Instances of a Field

      Please excuse the simplicity of this question, i am just getting started using Qlikview.   I am trying to count the number of unique employees in a record based on their work group.   I can display the data in a table but i want to get a calculated number of employees so that I can use this value in further productivity calculations.   The number of employees in a group changes on a daily basis due to sick time, vacation, etc.

       

      My data shows employee name, work center, and job type.   Example:

       

      Joe           Meter Shop          HIB199

      Joe           Meter Shop          HIB199

      Joe           Meter Shop         G34555

      Mary          Meter Shop         HIB199

      Mary          Meter Shop        JZZRT5

      James      Cafeteria             T44WTZ

      Tim           Cafeteria              T44WTZ

      Laura       Cafeteria              T44WTZ

       

      I need to be able to count the number of different employees in each work center.   So Meter Shop = 2 (Joe and Mary) and Cafeteria = 3 (James, Tim, Laura)

       

      I only need the number of employees in a work center, not the number of jobs they complete or the types of jobs.

       

      Thank you.