Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

arjinram
Not applicable

Writing Multiple IF Condition with Sum aggregate

Hi All,

I Need help with below requirement.

Data:  

TeamProcessActualTotalStandard
MTVECOM4010050%
MTVDTCKT609050%
LOAMLOTICKT9016050%
LOAMLODRAFT12020050%

Requirement : Want to Create a text box to show number of teams that met standard (i need the output in team level).


Condition: If 2 process of a team meets Standard( Actual/Total>=50%) then Teamstd count will be 1, else if only 1 team meets standard(>=50%) then it will be Teamstd counted as 0.

Explanation : In the above table for TEAM="MTV" only 1 team [ DTCKT Actual/Total >=50]  where as in TEAM="LOAM" for 2 process  Actual/Total <=50% so in the text box i want to show 1/2 (it says only 1 team out of 2 has 100% Success rate).

Please help.

Thanks in advance.

Arjin.

2 Replies
sunny_talwar
Not applicable

Re: Writing Multiple IF Condition with Sum aggregate

May be like this:

=Sum(Aggr(If(Sum(Aggr(If(Actual/Total >= 0.50, 1, 0), Team, Process)) = Count(Process), 1, 0), Team))/Count(DISTINCT Team)

arjinram
Not applicable

Re: Writing Multiple IF Condition with Sum aggregate

Hi Sunny,

It works perfect, Thanks alot.

Best Regards,

Arjin.