topic Continous mean calculation in QlikView https://community.qlik.com/t5/QlikView/Continous-mean-calculation/m-p/137009#M759313 <HTML><HEAD></HEAD><BODY><P>hello everyone </P><P></P><P>I have a table that holds this information</P><P></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">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Player</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Goal(s)</TH></TR><TR><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">Ronaldo</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">09/01/2018</TD><TD style="padding: 2px;">Messi</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">19/01/2018</SPAN></TD><TD style="padding: 2px;">Ronaldo </TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">09/02/2018</SPAN></TD><TD style="padding: 2px;">Ronaldo </TD><TD style="padding: 2px;"><P>3</P></TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">10/03/2018</SPAN></TD><TD>Ronaldo</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P>I need to calculate Ronaldo scoring rate as the time increase </P><P></P><P>As at 01/01/2018 to 01/01/2018</P><P>Ronaldo scoring ratio is 100% since one goal in one match</P><P>between the period 01/01/2016 to 10/03/2018&nbsp; His ratio is 75% (3/4)</P><P></P><P></P><P>How can I make it a dynamic system?</P><P></P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT akpofureenughwu 2020-11-25T16:16:04Z Continous mean calculation https://community.qlik.com/t5/QlikView/Continous-mean-calculation/m-p/137009#M759313 <HTML><HEAD></HEAD><BODY><P>hello everyone </P><P></P><P>I have a table that holds this information</P><P></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">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Player</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Goal(s)</TH></TR><TR><TD style="padding: 2px;">01/01/2018</TD><TD style="padding: 2px;">Ronaldo</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">09/01/2018</TD><TD style="padding: 2px;">Messi</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">19/01/2018</SPAN></TD><TD style="padding: 2px;">Ronaldo </TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">09/02/2018</SPAN></TD><TD style="padding: 2px;">Ronaldo </TD><TD style="padding: 2px;"><P>3</P></TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">10/03/2018</SPAN></TD><TD>Ronaldo</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P>I need to calculate Ronaldo scoring rate as the time increase </P><P></P><P>As at 01/01/2018 to 01/01/2018</P><P>Ronaldo scoring ratio is 100% since one goal in one match</P><P>between the period 01/01/2016 to 10/03/2018&nbsp; His ratio is 75% (3/4)</P><P></P><P></P><P>How can I make it a dynamic system?</P><P></P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Continous-mean-calculation/m-p/137009#M759313 akpofureenughwu 2020-11-25T16:16:04Z