Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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):
Project | Teammember | Teamsize |
A | Tick | 3 |
A | Trick | 3 |
A | Track | 3 |
B | Peter | 1 |
C | Colin | 2 |
C | Caro | 2 |
D | Daisy | 1 |
E | Erwin | 1 |
F | Bart | 4 |
F | Lisa | 4 |
F | Meggy | 4 |
F | Homer | 4 |
G | Leia | 1 |
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!
maybe this:
avg( aggr( if( count(Teammember) > 1, Teamsize ), Project ) )
I hope it helps.
maybe this:
avg( aggr( if( count(Teammember) > 1, Teamsize ), Project ) )
I hope it helps.