Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This text box expression is almost (but not quite) right...
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},REQUEST_ID ={"=sum(WORKFLOW_DURATION)>120"}>}REQUEST_ID)
I am trying to show the count of distinct request IDs where the CUR_WORKFLOW_STEP_NAME = 'Project Initiation and Design' and the sum(WORKFLOW_DURATION)>120. The catch is that a request may have been in Project Initiation and Design before, come out of it and is now back in it. That would mean, I think, taking the aggr sum of sum(WORKFLOW_DURATION)>120 for all rows in which WORKFLOW_STEP_NAME = 'Project Initiation and Design'
I believe I need to add an aggr before this part sum(WORKFLOW_DURATION)>120...
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},
REQUEST_ID ={"=AGGR(sum({$<WORKFLOW_STEP_NAME={Project Initiation and Design}>}WORKFLOW_DURATION)>120"}>}REQUEST_ID)
I was reading https://community.qlik.com/blogs/qlikviewdesignblog/2016/03/07/set-analysis-in-the-aggr-function and just can't figure out what's wrong.
Thanks!
This is a KPI in a text box, not a chart if that makes a difference.
That shouldn't be a problem - if you use a straight table, hide the caption (Caption -> Show Caption") as well as the Table headers (Presentation -> Suppress Header Row) and deactivate the expression totals (Expressions -> Total Mode = No Totals), you'll end up with a single value cell that you can present like a text box (so the user won't notice the different object type in the background).