topic Averages by Month in QlikView https://community.qlik.com/t5/QlikView/Averages-by-Month/m-p/1382094#M613960 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a question - i have a request from management to do a average by month for a running total of sale Deals.</P><P>In the view, we had rounded each rep to deal total by month, so the month always returns the first of the month so we can run totals by month.</P><P></P><P>So for example the table looks like this:</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>Sales Rep</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TotalDeals</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Month</STRONG></TH></TR><TR><TD style="padding: 2px;">John Doe</TD><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">09/1/2017</TD></TR><TR><TD style="padding: 2px;">Steve Joe</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">09/1/2017</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">John Doe</SPAN></TD><TD>5</TD><TD>08/01/2017</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">Steve Joe</SPAN></TD><TD>8</TD><TD>08/01/2017</TD></TR></TBODY></TABLE><P></P><P>I have sale deals coming in as a sum in a pivot as measures, the exec wants a running average... so if he chooses 5 months, he wants it to do an average by 5 months...</P><P></P><P>Sum(TotalDeals)/MONTHS CHOSEN</P><P></P><P>How would i return the selected months he is using, the date is a column and the measures are above.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 03 Oct 2017 00:02:23 GMT Anonymous 2017-10-03T00:02:23Z Averages by Month https://community.qlik.com/t5/QlikView/Averages-by-Month/m-p/1382094#M613960 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a question - i have a request from management to do a average by month for a running total of sale Deals.</P><P>In the view, we had rounded each rep to deal total by month, so the month always returns the first of the month so we can run totals by month.</P><P></P><P>So for example the table looks like this:</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>Sales Rep</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TotalDeals</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Month</STRONG></TH></TR><TR><TD style="padding: 2px;">John Doe</TD><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">09/1/2017</TD></TR><TR><TD style="padding: 2px;">Steve Joe</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">09/1/2017</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">John Doe</SPAN></TD><TD>5</TD><TD>08/01/2017</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">Steve Joe</SPAN></TD><TD>8</TD><TD>08/01/2017</TD></TR></TBODY></TABLE><P></P><P>I have sale deals coming in as a sum in a pivot as measures, the exec wants a running average... so if he chooses 5 months, he wants it to do an average by 5 months...</P><P></P><P>Sum(TotalDeals)/MONTHS CHOSEN</P><P></P><P>How would i return the selected months he is using, the date is a column and the measures are above.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 03 Oct 2017 00:02:23 GMT https://community.qlik.com/t5/QlikView/Averages-by-Month/m-p/1382094#M613960 Anonymous 2017-10-03T00:02:23Z Re: Averages by Month https://community.qlik.com/t5/QlikView/Averages-by-Month/m-p/1382095#M613961 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum(TotalDeals)/Count(DISTINCT Month)</STRONG></SPAN></P></BODY></HTML> Tue, 03 Oct 2017 00:30:37 GMT https://community.qlik.com/t5/QlikView/Averages-by-Month/m-p/1382095#M613961 sunny_talwar 2017-10-03T00:30:37Z