topic Re: Sum of Count expressions in App Development

Sum of Count expressions

Thu, 09 Jun 2016 05:06:56 GMT

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 — Thu, 09 Jun 2016 10:20:40 GMT

May be this:

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

Re: Sum of Count expressions

Fri, 10 Jun 2016 00:56:22 GMT

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	Percentage Commenced
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

sunny_talwar — Fri, 10 Jun 2016 10:47:56 GMT

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

Wed, 15 Jun 2016 23:21:13 GMT

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.