topic Re: Range Average Qlikview in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756713#M1485 <HTML><HEAD></HEAD><BODY><P>thank you Gysbert, it worked!</P></BODY></HTML> Thu, 18 Dec 2014 11:25:25 GMT 2014-12-18T11:25:25Z Range Average Qlikview https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756711#M1483 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate a moving average for customers. I want my table to show me the average of each customer based on his previous months data available. When I make a selection of a particular customer the table works fine. But problem arises when there is no selection on Contract. The table does not aggregate the moving average w.r.t to Customers. The query that i am currently using, which works fine for each Contract when selected, is:</P><P>Rangeavg(Above(TOTAL Sum(UnitBilled), 1, Rowno(TOTAL)))</P><P></P><P>However when there is no selection made the table shows the following details:</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73781_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>For each contract i want the table to show his own moving average. Like it is doing so for A in the above table.</P><P>Thanks!</P></BODY></HTML> Thu, 18 Dec 2014 06:37:57 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756711#M1483 2014-12-18T06:37:57Z Re: Range Average Qlikview https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756712#M1484 <HTML><HEAD></HEAD><BODY><P>Try removing the totals from the expression so the rangeavg does not cross the borders of the contact dimension:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rangeavg(Above(Sum(UnitBilled), 1, Rowno()))</SPAN></P></BODY></HTML> Thu, 18 Dec 2014 08:24:20 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756712#M1484 Gysbert_Wassenaar 2014-12-18T08:24:20Z Re: Range Average Qlikview https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756713#M1485 <HTML><HEAD></HEAD><BODY><P>thank you Gysbert, it worked!</P></BODY></HTML> Thu, 18 Dec 2014 11:25:25 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Range-Average-Qlikview/m-p/756713#M1485 2014-12-18T11:25:25Z