I am new to the QlikSense and I am now preparing a stacked bar chart to show the number of students in each proficiency level of 8 measurement tests. Since each measurement test has the same proficiency level categories, I create a table which allows the users to browse a particular measurement test and this forms the Stack of dimensions.
Besides, I want to display the chart by Gender or by School, so I add Gender and School into the Bar and Alternative dimensions correspondingly. The chart would be shown as follows:
However, under the Stack dimension, it provides the users to choose the alternative dimension "School", which is not my want. I just want users to select two things, 1) between Gender and School, 2) the name of test, therefore can someone help me to fix this problem? Many thanks!