topic comparing 2 fields in QlikView https://community.qlik.com/t5/QlikView/comparing-2-fields/m-p/502956#M1133646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm very uncertain with the code in Qlikview and don't know how to create grouped averages.</P><P></P><P>I've loaded data in the following format:-</P><P></P><P><SPAN style="text-decoration: underline;">STUDENTID COURSEID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROGRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FACULTY </SPAN></P><P>STUDENTX&nbsp; COURSEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Progressed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>SUTDENTY&nbsp; COURSEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Did not progress&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>STUDENTA&nbsp; COURSEB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Progressed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Courses are organised into departments and then into faculties.&nbsp; I want to compare, for example, a course progress with the faculty and overall progress.&nbsp; 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.</P><P></P><P>How do I create these faculty and overall averages and how do I use them in expressions?</P><P></P><P>Any help gratefully received.</P><P></P><P>Regards,</P><P></P><P>Racine62</P></BODY></HTML> Thu, 28 Nov 2013 12:20:49 GMT 2013-11-28T12:20:49Z comparing 2 fields https://community.qlik.com/t5/QlikView/comparing-2-fields/m-p/502956#M1133646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm very uncertain with the code in Qlikview and don't know how to create grouped averages.</P><P></P><P>I've loaded data in the following format:-</P><P></P><P><SPAN style="text-decoration: underline;">STUDENTID COURSEID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROGRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FACULTY </SPAN></P><P>STUDENTX&nbsp; COURSEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Progressed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>SUTDENTY&nbsp; COURSEA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Did not progress&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>STUDENTA&nbsp; COURSEB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Progressed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Courses are organised into departments and then into faculties.&nbsp; I want to compare, for example, a course progress with the faculty and overall progress.&nbsp; 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.</P><P></P><P>How do I create these faculty and overall averages and how do I use them in expressions?</P><P></P><P>Any help gratefully received.</P><P></P><P>Regards,</P><P></P><P>Racine62</P></BODY></HTML> Thu, 28 Nov 2013 12:20:49 GMT https://community.qlik.com/t5/QlikView/comparing-2-fields/m-p/502956#M1133646 2013-11-28T12:20:49Z