Sum of Count expressions

[#1]

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.

[sunny_talwar]

May be this:

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

[#3]

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%

[sunny_talwar · Accepted solution]

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

[#5]

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.