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

# Sum of Count expressions

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

May be this:

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

• ###### Re: Sum of Count expressions

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/2016 Percentage Commenced Total Comm Pend Suspend 112 52 12 48 81% 272 174 23 75 88% 233 142 15 76 90% 186 104 11 71 90% 148 84 13 51 87% 147 106 7 34 94% 202 113 9 80 93% 1300 775 90 435 89%
• ###### Re: Sum of Count expressions

May be this:

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

/

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

I think, the above is assuming that your dimension will only have one of the three PLACEMENT_STATUS_ CODE. May be share some information about your dimension, if the above doesn't work for you.

Best,

Sunny

• ###### Re: Sum of Count expressions

Thanks very much for that Sunny T. This format is new to me but I think I'm getting the general idea now. Thanks so much for helping to get me started.