topic Re: How to write the following formula ? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385620#M144001 <HTML><HEAD></HEAD><BODY><P>In addition, I tried to calculate the simple average by applying the following formula:</P><P>=rangeavg(above(avg(Sales),0,5))</P><P></P><P>But when facing the above weighted average formula, i couldn't think of any solution..... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 28 Nov 2012 10:27:51 GMT 2012-11-28T10:27:51Z How to write the following formula ? https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385619#M144000 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have problem to write the following formula and appreciate if someone here can help me.</P><P><IMG __jive_id="25692" alt="Average.jpg" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/25692_Average.jpg" width="450" /></P><P>Formula in excel is in the picture above.</P><P></P><P>Thanks a lot.</P></BODY></HTML> Wed, 28 Nov 2012 10:16:05 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385619#M144000 2012-11-28T10:16:05Z Re: How to write the following formula ? https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385620#M144001 <HTML><HEAD></HEAD><BODY><P>In addition, I tried to calculate the simple average by applying the following formula:</P><P>=rangeavg(above(avg(Sales),0,5))</P><P></P><P>But when facing the above weighted average formula, i couldn't think of any solution..... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 28 Nov 2012 10:27:51 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385620#M144001 2012-11-28T10:27:51Z Re: How to write the following formula ? https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385621#M144002 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>rangesum(sum(Sales)*5,above(sum(Sales))*4,above(sum(Sales),2,1)*3,above(sum(Sales),3,1)*2,above(sum(Sales),4,1) )/15</P></BODY></HTML> Wed, 28 Nov 2012 10:44:27 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385621#M144002 Gysbert_Wassenaar 2012-11-28T10:44:27Z Re: How to write the following formula ? https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385622#M144003 <HTML><HEAD></HEAD><BODY><P>Thanks! Gysbert! </P><P>But is there a way that can make this formula more dynamic by changing a day variable (this example here is 5 days and so, variable is 5)? What if I would like to make this formula to calculate 10/20/30 days weighted average?</P><P>Sorry that I didn't state very clear before.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 28 Nov 2012 15:44:13 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-following-formula/m-p/385622#M144003 2012-11-28T15:44:13Z