topic 52 weeks average in Chart in QlikView https://community.qlik.com/t5/QlikView/52-weeks-average-in-Chart/m-p/1173795#M381240 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Data is like, </P><TABLE border="1" class="jiveBorder" height="144" style="border: 1px solid rgb(0, 0, 0); width: 183px; height: 117px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Week</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">2016-01</TD><TD style="padding: 2px;">600</TD></TR><TR><TD style="padding: 2px;">2016-02</TD><TD style="padding: 2px;"><P>400</P></TD></TR><TR><TD>2016-03</TD><TD><P>100</P></TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>We have data for the past 3 years loaded, and the user can select any particular weeks. I have a line chart with Week as dimension and avg(Amount) as expression and all is fine. Now i need to show 52 week average in the line chart, along with the selected weeks. 52 Week average can be calculated as avg of past 52 weeks data. How can i achieve this?</P><P></P><P>Thanks</P><P>KRS</P></BODY></HTML> Tue, 05 Jul 2016 08:30:02 GMT krishnaroopa 2016-07-05T08:30:02Z 52 weeks average in Chart https://community.qlik.com/t5/QlikView/52-weeks-average-in-Chart/m-p/1173795#M381240 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Data is like, </P><TABLE border="1" class="jiveBorder" height="144" style="border: 1px solid rgb(0, 0, 0); width: 183px; height: 117px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Week</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">2016-01</TD><TD style="padding: 2px;">600</TD></TR><TR><TD style="padding: 2px;">2016-02</TD><TD style="padding: 2px;"><P>400</P></TD></TR><TR><TD>2016-03</TD><TD><P>100</P></TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>We have data for the past 3 years loaded, and the user can select any particular weeks. I have a line chart with Week as dimension and avg(Amount) as expression and all is fine. Now i need to show 52 week average in the line chart, along with the selected weeks. 52 Week average can be calculated as avg of past 52 weeks data. How can i achieve this?</P><P></P><P>Thanks</P><P>KRS</P></BODY></HTML> Tue, 05 Jul 2016 08:30:02 GMT https://community.qlik.com/t5/QlikView/52-weeks-average-in-Chart/m-p/1173795#M381240 krishnaroopa 2016-07-05T08:30:02Z