topic Re: Set Analysis Syntax Help in QlikView

Set Analysis Syntax Help

cbaqir — Fri, 22 Jan 2016 20:28:59 GMT

I am trying to display a text box that shows a count of REQUEST_ID where CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design' and where sum(WORKFLOW_DURATION)>=120. Thesum(WORKFLOW_DURATION) should just refer to WORKFLOW_DURATION for 'Project Initiation and Design. I keep getting an error. What am I doing wrong?

=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design',sum(WORKFLOW_DURATION)={">=$(>=120)"}>}REQUEST_ID)

Thanks,

Cassandra

Re: Set Analysis Syntax Help

ramoncova06 — Fri, 22 Jan 2016 20:32:50 GMT

try with this

=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},REQUEST_ID ={"=sum(WORKFLOW_DURATION)>=120"}>}REQUEST_ID)

Re: Set Analysis Syntax Help

Fri, 22 Jan 2016 20:33:47 GMT

You can't use the Sum function directly in place of field.

Try like below:

=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design', REQUEST_ID={"=sum(WORKFLOW_DURATION)>120"}>}REQUEST_ID)

Re: Set Analysis Syntax Help

swuehl — Fri, 22 Jan 2016 20:34:39 GMT

I assume you want to sum() per Request_ID:

=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design', REQUEST_ID = {"=sum(WORKFLOW_DURATION)>=120)"}>}REQUEST_ID)