Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Set Analysis Syntax Help

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

Tags (2)
1 Solution

Accepted Solutions
ramoncova06
Valued Contributor III

Re: Set Analysis Syntax Help

try with this

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

3 Replies
ramoncova06
Valued Contributor III

Re: Set Analysis Syntax Help

try with this

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

Not applicable

Re: Set Analysis Syntax Help

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)

MVP
MVP

Re: Set Analysis Syntax Help

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)

Community Browser