Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average of Average Expression

Hi All,

I need to get the average across the 4 student per category highlighted in red. 

For now, I can get the average score per student for each category.  I am using the following expression:

=(SUM({$(eMPE_Set)}QuestionData)/

COUNT({$(eMPE_Set)} Record_No))/

Max({$(eMPE_Set)}MaxRatingScore)

The MPE expression is a set expression to get a specific exam type, example.  English. 

1. QuestionData is the score value. 

2. Record No is a count of the number of records.

3. MaxRating Score is the maximum score of each questions. 

4.  The result of the above expression is translate into %.

What am I missing?  Can anyone please guide me on this?

Thanks

Chun Wey

Sample.jpg

10 Replies
Not applicable
Author

Thanks Tresesco! You're good!!