Hi,
I'm very uncertain with the code in Qlikview and don't know how to create grouped averages.
I've loaded data in the following format:-
STUDENTID COURSEID PROGRESS FACULTY
STUDENTX COURSEA Progressed A
SUTDENTY COURSEA Did not progress A
STUDENTA COURSEB Progressed B etc
Courses are organised into departments and then into faculties. I want to compare, for example, a course progress with the faculty and overall progress. So when clicking down the hierachy (Uni level, Faculty level, Department level, course level) the comparison is made with the faculty progress and the overall.
How do I create these faculty and overall averages and how do I use them in expressions?
Any help gratefully received.
Regards,
Racine62