Chart

[Harsha1]

Student_id , Student_name, Class, subject , Marks , Date_of_exam are the columns in my table 

Bonus report : Number of student who have got more marks then the class average.

I need to generate a chart for the above condition i tried multiple ways but not able to succeed. #QlikSense

QlikView 

[Harsha1]

• Can some one please help me on this 

[MayilVahanan · Accepted solution]

Hi @Harsha1 

Try like below

Year field derived based on ExamDate.

Exp:

Sum(Aggr(If(Avg(Total<Class, Year> Marks) <= Avg(Marks), 1, 0), Class, Student_name, Year))

[Harsha1]

Thanks somuch