topic Re: Average and Constant in QlikView https://community.qlik.com/t5/QlikView/Average-and-Constant/m-p/663310#M1061569 <HTML><HEAD></HEAD><BODY><P>You can use an if statement to evaluate one expression for number of students, then another for everything else like:</P><P></P><P><STRONG>if(Result = 'Number of Students', sum(Data), RangeAvg(Before(Data),Data))</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 22 Sep 2014 16:42:31 GMT jerem1234 2014-09-22T16:42:31Z Average and Constant https://community.qlik.com/t5/QlikView/Average-and-Constant/m-p/663309#M1061567 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>Please advise how to make headcount (No.of Students) to be fixed (ie. as numbers as worksheet, not average) with averages for English and Science subjects in one report.</P><P></P><P>Thank You for your help</P><P>Tracy&nbsp; </P></BODY></HTML> Mon, 22 Sep 2014 16:36:21 GMT https://community.qlik.com/t5/QlikView/Average-and-Constant/m-p/663309#M1061567 tracycrown 2014-09-22T16:36:21Z Re: Average and Constant https://community.qlik.com/t5/QlikView/Average-and-Constant/m-p/663310#M1061569 <HTML><HEAD></HEAD><BODY><P>You can use an if statement to evaluate one expression for number of students, then another for everything else like:</P><P></P><P><STRONG>if(Result = 'Number of Students', sum(Data), RangeAvg(Before(Data),Data))</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 22 Sep 2014 16:42:31 GMT https://community.qlik.com/t5/QlikView/Average-and-Constant/m-p/663310#M1061569 jerem1234 2014-09-22T16:42:31Z