Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of Plan finished

Dear all,
I have the following structure:
PlanPlaceActivity# CardsFlag_Act Finished
L1DFA110001
L1DFA115001
L1DFA111001
L2DFA110010
L2DFA210021
L2DFA215261
L2DFA214521
L2CDA318951
L3CDA324110
L3CDA326330
L3CDA411021
L4CDA411031
L4CDA412041
L4CDA412251
L4CDA413651
I would like to know how much Plan are done, considering that all the Flag in the column Flag_Act Finished must be 1. If one activity is 0, the plan is unfinished. In this case, total of plan finished = 2, (L1 and L4)
The same thing, I would like to know how many plan are done per places, considering the same rules.
Must be a simple thing to do, but cannot figure out.
Thanks in advance for any help, idea submited.
Patrick
1 Solution

Accepted Solutions
swuehl
MVP
MVP

You could try something like

=sum(aggr( if(sum([Flag_Act Finished])=count([Flag_Act Finished]),1,0), Plan))

Check for each Plan ( L1 to L4 ), if sum of flag equals the count (if there is any zero flag, there will be a difference).

View solution in original post

2 Replies
swuehl
MVP
MVP

You could try something like

=sum(aggr( if(sum([Flag_Act Finished])=count([Flag_Act Finished]),1,0), Plan))

Check for each Plan ( L1 to L4 ), if sum of flag equals the count (if there is any zero flag, there will be a difference).

Not applicable
Author

That was quick, A lots of thanks, so simple and I didn't think about it.