10 Replies Latest reply: Dec 15, 2017 10:31 AM by Zaid Alemam RSS

    How to Count and Group different values in a column?

    Zaid Alemam

      Hi All,

       

      New to Qlik Sense, and manipulation of data.

       

      I'm trying to count certain values in a column then have them grouped up and displayed as a sum of one number.

       

      For example:

       

      This is what values are in a column:

       

       

      L0 Status
      Awaiting Feedback from Business/BA
      Estimate Completed
      Estimate Requested (Past Due Date)
      Request Approved
      Request Approved (Funded Supplier)
      Cancelled

       

      I want all the 'Awaiting Feedback', 'Estimate Completed', 'Estimate Requested' to be counted together and displayed as 'In Progress'

       

      Any help is appreciated.

       

      Thanks