Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
nroy12
Contributor II
Contributor II

set analysis aggr function with logical operator

hi all,

whats wrong with my expression?

i am  trying to transfer the logic of the load script in report expression as below:

If(Match(Workflow_Name,'EMEA Start Review Cycle') and Match(TaskName,'Other Review') or Match(TaskName,'EMEA Scientific Department 1 Review')or Match(TaskName,'EMEA Scientific Department 2 Review'),1) as rev_start_counter,

 

to

=Aggr(sum({<workflow_name = {'Workflow_Name,'EMEA Start Review Cycle'}, task_name = {'Other Review'}/ task_name={'EMEA Scientific Department 1 Review'}/task_name{'EMEA Scientific Department 2 Review'} >} 1) ,document_number)

 

 

=Aggr(Sum({(<workflow_name='EMEA Start Review Cycle'> , <task_name='Other Review'>) + <task_name='EMEA Scientific Department 1 Review'> + <task_name='EMEA Scientific Department 2 Review'>}1),document_number)

 

no error came but the expected value also did not come.

kindly help.

thanks,

 

Labels (2)
0 Replies