topic Aggregating different levels in same chart in QlikView https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838017#M1015617 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a comparison chart that I need to make in a dashboard. We want to show the split by gender of students in our departments compared to the college and the faculty - so there are three levels of aggregation. Each department is in a faculty and each faculty is part of the whole college. We have 3 faculties, each with 5-10 departments.</P><P></P><P>I want a stacked bar chart that shows the percentage of male and female in the same bar and 3 bars next to each other. However, when I do the calculations I cannot get it to calculate the three things separately. Also, it stacks all 6 calculations into one bar which is not what I need. Is it possible to stack the expressions separately?</P><P></P><P>Thanks for your help</P><P><BR />Alison</P></BODY></HTML> Wed, 15 Apr 2015 11:07:53 GMT alisonpwallis 2015-04-15T11:07:53Z Aggregating different levels in same chart https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838017#M1015617 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a comparison chart that I need to make in a dashboard. We want to show the split by gender of students in our departments compared to the college and the faculty - so there are three levels of aggregation. Each department is in a faculty and each faculty is part of the whole college. We have 3 faculties, each with 5-10 departments.</P><P></P><P>I want a stacked bar chart that shows the percentage of male and female in the same bar and 3 bars next to each other. However, when I do the calculations I cannot get it to calculate the three things separately. Also, it stacks all 6 calculations into one bar which is not what I need. Is it possible to stack the expressions separately?</P><P></P><P>Thanks for your help</P><P><BR />Alison</P></BODY></HTML> Wed, 15 Apr 2015 11:07:53 GMT https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838017#M1015617 alisonpwallis 2015-04-15T11:07:53Z Re: Aggregating different levels in same chart https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838018#M1015618 <HTML><HEAD></HEAD><BODY><P>Provide sample data please!</P></BODY></HTML> Wed, 15 Apr 2015 11:10:48 GMT https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838018#M1015618 MK_QSL 2015-04-15T11:10:48Z Re: Aggregating different levels in same chart https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838019#M1015619 <HTML><HEAD></HEAD><BODY><P>what column are you adding to the dimensions tab?</P></BODY></HTML> Wed, 15 Apr 2015 11:11:17 GMT https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838019#M1015619 ali_hijazi 2015-04-15T11:11:17Z Re: Aggregating different levels in same chart https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838020#M1015620 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Here is a sample of my data - it's a cut down version of the whole set. </P><P></P><P>In the chart I want three bars next to each other - college, faculty and department. Is there a way to do it?</P><P></P><P>Thanks</P><P><BR />Alison</P></BODY></HTML> Wed, 15 Apr 2015 11:30:27 GMT https://community.qlik.com/t5/QlikView/Aggregating-different-levels-in-same-chart/m-p/838020#M1015620 alisonpwallis 2015-04-15T11:30:27Z