Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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.

1 Solution

Accepted Solutions
MVP
MVP

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

4 Replies
MVP
MVP

Re: Sum of Count expressions

May be this:

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

Not applicable

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/2016Percentage Commenced
TotalCommPendSuspend
11252124881%
272174237588%
233142157690%
186104117190%
14884135187%
14710673494%
20211398093%
13007759043589%
MVP
MVP

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

Not applicable

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.