topic Re: Average range in qlik sense in App Development https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114666#M7940 <HTML><HEAD></HEAD><BODY><P>Is this something you need in the script?</P></BODY></HTML> Thu, 18 Oct 2018 10:44:09 GMT sunny_talwar 2018-10-18T10:44:09Z Average range in qlik sense https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114665#M7939 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I have a problem about to calculate average a range. like my example below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Equity</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">3000</TD></TR></TBODY></TABLE><P>I want my result is a column with accumulate average UNIQUE Equity</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Equity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">average Equity</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">1500</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">1166.67 = (1000+2000+500)/3</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">1166.67</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">3000</TD><TD style="padding: 2px;">1625</TD></TR></TBODY></TABLE><P></P><P>Please help me if you have any solution for this</P><P></P><P>Many Thanks,</P></BODY></HTML> Thu, 18 Oct 2018 04:27:12 GMT https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114665#M7939 phongnnguyen 2018-10-18T04:27:12Z Re: Average range in qlik sense https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114666#M7940 <HTML><HEAD></HEAD><BODY><P>Is this something you need in the script?</P></BODY></HTML> Thu, 18 Oct 2018 10:44:09 GMT https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114666#M7940 sunny_talwar 2018-10-18T10:44:09Z Re: Average range in qlik sense https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114667#M7941 <HTML><HEAD></HEAD><BODY><P>Actually, I want to set my analysis to do that. I tried to use rangeAvg but it is not working.</P></BODY></HTML> Fri, 19 Oct 2018 01:45:34 GMT https://community.qlik.com/t5/App-Development/Average-range-in-qlik-sense/m-p/114667#M7941 phongnnguyen 2018-10-19T01:45:34Z