topic Count with set expression? in QlikView

Count with set expression?

Anonymous — Thu, 06 Nov 2014 15:20:46 GMT

Hello,

I've got the following data:

student/grade

a =2

a=3

b=0

c=3

I'd like to calculate the average grade among the student with significant values:

(2+3+3)/2=4

How can I express this formula with something like as: Sum(value)/count (DISTINCT student)?

Thks.

Re: Count with set expression?

MK_QSL — Thu, 06 Nov 2014 15:41:13 GMT

SUM(Grade)/Count(Distinct Student)

SUM(Grade)/Count({<Student = {"=SUM(Grade)>0"}>}Distinct Student)

Re: Count with set expression?

Anonymous — Thu, 06 Nov 2014 15:49:20 GMT

The first one is what i've written, but it's wrong because it counts also B student, who is without grade; contrariwise the second one is perfect...just what I need.

Thank you very much.