Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Sum of Plan finished

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).

2 Replies
MVP
MVP

Re: Sum of Plan finished

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

Re: Sum of Plan finished

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

Community Browser