Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

SUM IF/ COUNT IF Problem

Hello, I hope the question was not asked already, but so far I have not found a answer to my problem. (But I have to admit that I am a complete qlik beginner)

Here a selcection of the columns that I have in a table (the actual table is much bigger but has company sensitive data):

ProjectTeammemberTeamsize
ATick3
ATrick3
ATrack3
BPeter1
CColin2
CCaro2
DDaisy1
EErwin1
FBart4
FLisa4
FMeggy4
FHomer4
GLeia1

 

What I want to do: I want to have a formula for a KPR, that gives me the average teamsize of teams with more than 1 teammembers. It is easy maths, but I don't know how to do the formula in qlik. (Especially because every team must only be counted once, although it appears multiple times in the list...)

Thanks in advance, I really appreciate your help!

Labels (4)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: SUM IF/ COUNT IF Problem

maybe this:

avg( aggr( if( count(Teammember) > 1, Teamsize ), Project ) )

I hope it helps.

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: SUM IF/ COUNT IF Problem

maybe this:

avg( aggr( if( count(Teammember) > 1, Teamsize ), Project ) )

I hope it helps.

View solution in original post