4 Replies Latest reply: Jun 15, 2016 7:21 PM by Chris Ellingworth RSS

    Sum of Count expressions

    Chris Ellingworth

      Can you please help me sum these count expressions so that the results can appear in a new column in my table in Qlik Sense:

       

      Count({$<PLACEMENT_STATUS_CODE={'COM'}>}Job_Seeker_ID)

       

      and

       

      Count({$<PLACEMENT_STATUS_CODE={'PND'}>}Job_Seeker_ID)

       

       

      Thanks.

        • Re: Sum of Count expressions
          Sunny Talwar

          May be this:

           

          Count({$<PLACEMENT_STATUS_CODE={'COM', 'PND'}>} Job_Seeker_ID)

            • Re: Sum of Count expressions
              Chris Ellingworth

              Thanks very much Sunny.

              If I have expressions that work out the Counts for Total, Comm, Pend and Suspend then how can I get the Percentage Commenced result when I would normally use the following equation:

              Percentage Commenced = Comm/(Total-Suspend)?

               

              Comm = Count({$<PLACEMENT_STATUS_CODE={'COM'}>}PLACEMENT_STATUS_CODE)

              Suspend = Count({$<PLACEMENT_STATUS_CODE={'SUS'}>}PLACEMENT_STATUS_CODE)

              Total = Count({$<PLACEMENT_STATUS_CODE={'COM','PND','SUS'}>}PLACEMENT_STATUS_CODE)

                 

              3/06/2016Percentage Commenced
              TotalCommPendSuspend
              11252124881%
              272174237588%
              233142157690%
              186104117190%
              14884135187%
              14710673494%
              20211398093%
              13007759043589%