Expression To Sum and breakdown the count

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an expression to count new apps and when the cursor is over the value, I will like to display the breakdown of the count. Below is my formula used however the breakdown is not accurate although the count is right.

=num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} PersonApplicationGUID), '##0')

&chr(10)&

'Both Time: ' & num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedBothStatus), '##0')

&chr(10)&

'Full Time: ' & num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedFullTimeFlag), '##0')

&chr(10)&

'Part Time: ' & num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedPartTimeFlag), '##0')

&chr(10)&

'Missing Status: ' & num(sum({$<ApplicationStatusCode-={'DUPLAP'}, ApplicationDate={"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RequestedMissingStatus), '##0')

Thanks

Re: Expression To Sum and breakdown the count

Digvijay_Singh — Mon, 19 Mar 2018 21:26:35 GMT

What are the chart dimensions you have? You may surround it with Aggr along with chart dimensions, not sure though, sample data will help to understand the issue

topic Expression To Sum and breakdown the count in QlikView

Expression To Sum and breakdown the count

Re: Expression To Sum and breakdown the count