SUM IF/ COUNT IF Problem

frfr — Sat, 16 Nov 2024 19:25:36 GMT

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!

Re: SUM IF/ COUNT IF Problem

agigliotti — Wed, 18 Dec 2019 16:54:52 GMT

maybe this:

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

I hope it helps.

topic Re: SUM IF/ COUNT IF Problem in QlikView

SUM IF/ COUNT IF Problem

Re: SUM IF/ COUNT IF Problem