topic Problem: Total number in a selection in QlikView https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550219#M1126990 <HTML><HEAD></HEAD><BODY><P>I'm developing a QV document that, among other things, are going to calculate average absence data for a number of schools per Term.</P><P></P><P>I have to divide the number of days absent (column C)&nbsp; on the number of students in the current selection (column A). However, I can't just divide the data for absence code GFE on the number of students with the absence code GFE, I have to divide it on the total number of students in the current selection in the school. That is, for school X I have to divide the different numbers in column C on the total 1, and for school Y I have to divide the numbers on total 68.</P><P></P><P>I can't divide on the number of students at the school, because not everyone is registered at each term. I have to have an expression that divides on the total number of students in the current selection at each school. Ie 505 for School X, and 68 for school Y.</P><P></P><P>Expression for Number of days absent: sum(Sessions)</P><P>Expression for Average: (Sum(Sessions))/count(total{$}PersonCounter)</P><P>Expression for number of students: sum(PersonCounter)</P><P>Expression for number of students at the school: sum(OrgPersonCount)</P><P></P><P>To clarify: I need an expression that will calculate the GFE for School X to be 0,97 (488 number of days absent/505 total number of students in the selection for school X).</P><P></P><P>Any suggestions?</P><P></P><P>Message was edited by: Joachim Hollekim</P></BODY></HTML> Fri, 03 Jan 2014 14:44:52 GMT 2014-01-03T14:44:52Z Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550219#M1126990 <HTML><HEAD></HEAD><BODY><P>I'm developing a QV document that, among other things, are going to calculate average absence data for a number of schools per Term.</P><P></P><P>I have to divide the number of days absent (column C)&nbsp; on the number of students in the current selection (column A). However, I can't just divide the data for absence code GFE on the number of students with the absence code GFE, I have to divide it on the total number of students in the current selection in the school. That is, for school X I have to divide the different numbers in column C on the total 1, and for school Y I have to divide the numbers on total 68.</P><P></P><P>I can't divide on the number of students at the school, because not everyone is registered at each term. I have to have an expression that divides on the total number of students in the current selection at each school. Ie 505 for School X, and 68 for school Y.</P><P></P><P>Expression for Number of days absent: sum(Sessions)</P><P>Expression for Average: (Sum(Sessions))/count(total{$}PersonCounter)</P><P>Expression for number of students: sum(PersonCounter)</P><P>Expression for number of students at the school: sum(OrgPersonCount)</P><P></P><P>To clarify: I need an expression that will calculate the GFE for School X to be 0,97 (488 number of days absent/505 total number of students in the selection for school X).</P><P></P><P>Any suggestions?</P><P></P><P>Message was edited by: Joachim Hollekim</P></BODY></HTML> Fri, 03 Jan 2014 14:44:52 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550219#M1126990 2014-01-03T14:44:52Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550220#M1126991 <HTML><HEAD></HEAD><BODY><P>could you share part of the Application?</P></BODY></HTML> Fri, 03 Jan 2014 14:55:48 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550220#M1126991 rustyfishbones 2014-01-03T14:55:48Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550221#M1126992 <HTML><HEAD></HEAD><BODY><P>Not sure if I fully understood, a sample application with your expected results may help.</P><P></P><P>You can look into using TOTAL with a field list, like</P><P></P><P>=count(<STRONG>TOTAL&lt;Organization&gt;</STRONG> PersonCounter)</P></BODY></HTML> Fri, 03 Jan 2014 14:55:50 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550221#M1126992 swuehl 2014-01-03T14:55:50Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550222#M1126993 <HTML><HEAD></HEAD><BODY><P>What do you need?</P></BODY></HTML> Fri, 03 Jan 2014 15:01:45 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550222#M1126993 2014-01-03T15:01:45Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550223#M1126994 <HTML><HEAD></HEAD><BODY><P>Sorry, that did not work. <IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/51036_Capture.JPG.jpg" style="width: 620px; height: 230px;" /></P></BODY></HTML> Fri, 03 Jan 2014 15:03:03 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550223#M1126994 2014-01-03T15:03:03Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550224#M1126995 <HTML><HEAD></HEAD><BODY><P>the qvw you are working on, or a reduced data version of it</P></BODY></HTML> Fri, 03 Jan 2014 15:05:32 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550224#M1126995 rustyfishbones 2014-01-03T15:05:32Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550225#M1126997 <HTML><HEAD></HEAD><BODY><P>Ah, I see. I have attached an example to my original post.</P></BODY></HTML> Fri, 03 Jan 2014 15:12:53 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550225#M1126997 2014-01-03T15:12:53Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550226#M1127000 <HTML><HEAD></HEAD><BODY><P>Try this as expression for the average: Sum(Sessions)/sum(total &lt;OrganisationTitle&gt; PersonCounter)</P></BODY></HTML> Fri, 03 Jan 2014 15:21:17 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550226#M1127000 Gysbert_Wassenaar 2014-01-03T15:21:17Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550227#M1127005 <HTML><HEAD></HEAD><BODY><P>You need to use the correct field name for your dimension Organization:</P><P></P><P>=count(total&lt;[OrganisationTitle]&gt;&nbsp; PersonCounter)</P></BODY></HTML> Fri, 03 Jan 2014 15:21:20 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550227#M1127005 swuehl 2014-01-03T15:21:20Z Re: Problem: Total number in a selection https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550228#M1127008 <HTML><HEAD></HEAD><BODY><P>That did it! Thank you very much!</P></BODY></HTML> Fri, 03 Jan 2014 15:25:33 GMT https://community.qlik.com/t5/QlikView/Problem-Total-number-in-a-selection/m-p/550228#M1127008 2014-01-03T15:25:33Z