topic Re: calculation on slippery weeks in App Development https://community.qlik.com/t5/App-Development/calculation-on-slippery-weeks/m-p/1423224#M33869 <HTML><HEAD></HEAD><BODY><P>1- ((RangeAvg(above(Sum([Nb MP 7 days]),0,5))) / (RangeAvg(above(Sum([Nb WOL 7 days]),0,5))))</P></BODY></HTML> Mon, 21 Aug 2017 12:26:05 GMT 2017-08-21T12:26:05Z calculation on slippery weeks https://community.qlik.com/t5/App-Development/calculation-on-slippery-weeks/m-p/1423223#M33868 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>I need to do a calculation on slippery weeks in order to make previsions. and I don't know how to do it.</P><P></P><P>Have see in the snapshot, the calcul is done on Excel, I want to do the same on Qlik Sense.</P><P></P><P>I tried to use RangeAvg function, but I dont know how to specify the range, an also I think there should be some spécifications in the limits of the fields</P><P></P><P>Helppp and thanks</P></BODY></HTML> Fri, 18 Aug 2017 09:45:27 GMT https://community.qlik.com/t5/App-Development/calculation-on-slippery-weeks/m-p/1423223#M33868 2017-08-18T09:45:27Z Re: calculation on slippery weeks https://community.qlik.com/t5/App-Development/calculation-on-slippery-weeks/m-p/1423224#M33869 <HTML><HEAD></HEAD><BODY><P>1- ((RangeAvg(above(Sum([Nb MP 7 days]),0,5))) / (RangeAvg(above(Sum([Nb WOL 7 days]),0,5))))</P></BODY></HTML> Mon, 21 Aug 2017 12:26:05 GMT https://community.qlik.com/t5/App-Development/calculation-on-slippery-weeks/m-p/1423224#M33869 2017-08-21T12:26:05Z