https://community.qlik.com/t5/QlikView/Hierarchy-for-Data-Point-Comparison-between-Items-separated-by-0/m-p/297838#M1184056 <HTML><HEAD></HEAD><BODY><P>Scenario: Very large data set of student marks in numerous courses, many of which have prerequisites also in the dataset.</P><P></P><P>I would like to produce an application in which the user can click on a course, discover and select it's immediate or distant prerequisites, and show marks of students having taken both courses for both courses for a comparative analysis. (eg, scatter graph of student marks in A on one axis against student marks in B on the other.) </P><P></P><P>Simplified data tables look like </P><P></P><P>CourseMarks</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CourseID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; StudentID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Mark</P><P>...</P><P></P><P>Prerequisites</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CourseID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PrerequisiteCourseID</P><P></P><P>Do I use a load resident on the fact table? How can I link this to the dynamically selected prerequisite? Or is there a better way?</P><P></P><P>I'm fairly new to QV, so I'd appreciate any thoughts on the load (especially!) and/or sheet object implementation. </P><P></P><P>Thanks,</P><P>Tom</P></BODY></HTML> Tue, 13 Dec 2011 22:48:36 GMT 2011-12-13T22:48:36Z https://community.qlik.com/t5/QlikView/Hierarchy-for-Data-Point-Comparison-between-Items-separated-by-0/m-p/297838#M1184056 <HTML><HEAD></HEAD><BODY><P>Scenario: Very large data set of student marks in numerous courses, many of which have prerequisites also in the dataset.</P><P></P><P>I would like to produce an application in which the user can click on a course, discover and select it's immediate or distant prerequisites, and show marks of students having taken both courses for both courses for a comparative analysis. (eg, scatter graph of student marks in A on one axis against student marks in B on the other.) </P><P></P><P>Simplified data tables look like </P><P></P><P>CourseMarks</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CourseID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; StudentID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Mark</P><P>...</P><P></P><P>Prerequisites</P><P>&nbsp;&nbsp;&nbsp;&nbsp; CourseID</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PrerequisiteCourseID</P><P></P><P>Do I use a load resident on the fact table? How can I link this to the dynamically selected prerequisite? Or is there a better way?</P><P></P><P>I'm fairly new to QV, so I'd appreciate any thoughts on the load (especially!) and/or sheet object implementation. </P><P></P><P>Thanks,</P><P>Tom</P></BODY></HTML> Tue, 13 Dec 2011 22:48:36 GMT https://community.qlik.com/t5/QlikView/Hierarchy-for-Data-Point-Comparison-between-Items-separated-by-0/m-p/297838#M1184056 2011-12-13T22:48:36Z