topic Average Sales in QlikView https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750161#M1023069 <HTML><HEAD></HEAD><BODY><P>Hi all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I am new in Qlikview but I need to set up a overview showing 6 months rolling average.</P><P>My inputt file look like this:</P><P>Unit, Month, Year,Salesmann, Customer name,Product name, Volume, Net Sales, GM</P></BODY></HTML> Thu, 19 Mar 2015 12:36:36 GMT 2015-03-19T12:36:36Z Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750161#M1023069 <HTML><HEAD></HEAD><BODY><P>Hi all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I am new in Qlikview but I need to set up a overview showing 6 months rolling average.</P><P>My inputt file look like this:</P><P>Unit, Month, Year,Salesmann, Customer name,Product name, Volume, Net Sales, GM</P></BODY></HTML> Thu, 19 Mar 2015 12:36:36 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750161#M1023069 2015-03-19T12:36:36Z Re: Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750162#M1023071 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P><A href="https://community.qlik.com/docs/DOC-4821">Simply create YTD, moving totals and comparisons versus Year Ago</A></P></BODY></HTML> Thu, 19 Mar 2015 21:50:39 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750162#M1023071 Anonymous 2015-03-19T21:50:39Z Re: Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750163#M1023072 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Can you upload your sample data file?</P></BODY></HTML> Fri, 20 Mar 2015 05:59:22 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750163#M1023072 2015-03-20T05:59:22Z Re: Average Sales https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750164#M1023074 <HTML><HEAD></HEAD><BODY><P>How to:</P><P><A href="https://community.qlik.com/docs/DOC-8009">Expression Scene Investigation, E1: Moving Average</A></P></BODY></HTML> Fri, 20 Mar 2015 06:11:47 GMT https://community.qlik.com/t5/QlikView/Average-Sales/m-p/750164#M1023074 robert_mika 2015-03-20T06:11:47Z