topic Avg By Month in QlikView https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260697#M849564 <HTML><HEAD></HEAD><BODY><P>Hi I am trying to calculate the avg by month</P><P></P><P>Data</P><P>Table 1</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><TBODY><TR><TD class="xl69" height="20" style="border: 0px solid black; border-image: none;" width="73">Date</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="64">Count</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="159">Month</TD></TR><TR><TD class="xl66" height="20" style="border: 0px solid black; border-image: none;">2015-03-11</TD><TD align="right" class="xl67" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">3</TD><TD align="right" class="xl68" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-03-12</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">6</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-03-13</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-05</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">7</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-06</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">2</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-08</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">2</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-12</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-13</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">5</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-14</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">3</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-01</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">6</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-02</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">8</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-03</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">9</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR></TBODY></TABLE><P></P><P>Output</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><TBODY><TR><TD class="xl69" height="20" style="border: 0px solid black; border-image: none;" width="73">Month</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="159">Average Count Per Month</TD></TR><TR><TD class="xl66" height="20" style="border: 0px solid black; border-image: none;">Mar</TD><TD align="right" class="xl68" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">4.33</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">Apr</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">3.67</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">May</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4.00</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">Jun</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">7.67</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT dsharmaqv 2020-11-25T16:16:04Z Avg By Month https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260697#M849564 <HTML><HEAD></HEAD><BODY><P>Hi I am trying to calculate the avg by month</P><P></P><P>Data</P><P>Table 1</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><TBODY><TR><TD class="xl69" height="20" style="border: 0px solid black; border-image: none;" width="73">Date</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="64">Count</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="159">Month</TD></TR><TR><TD class="xl66" height="20" style="border: 0px solid black; border-image: none;">2015-03-11</TD><TD align="right" class="xl67" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">3</TD><TD align="right" class="xl68" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-03-12</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">6</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-03-13</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Mar</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-05</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">7</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-06</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">2</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-04-08</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">2</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Apr</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-12</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-13</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">5</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-05-14</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">3</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">May</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-01</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">6</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-02</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">8</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">2015-06-03</TD><TD align="right" class="xl64" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">9</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">Jun</TD></TR></TBODY></TABLE><P></P><P>Output</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><TBODY><TR><TD class="xl69" height="20" style="border: 0px solid black; border-image: none;" width="73">Month</TD><TD class="xl70" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="159">Average Count Per Month</TD></TR><TR><TD class="xl66" height="20" style="border: 0px solid black; border-image: none;">Mar</TD><TD align="right" class="xl68" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;">4.33</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">Apr</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">3.67</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">May</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">4.00</TD></TR><TR><TD class="xl63" height="20" style="border-width: medium 0px 0px; border-style: none solid solid; border-color: currentColor black black;">Jun</TD><TD align="right" class="xl65" style="border-width: medium 0px 0px medium; border-style: none solid solid none; border-color: currentColor black black currentColor;">7.67</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260697#M849564 dsharmaqv 2020-11-25T16:16:04Z Re: Avg By Month https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260698#M849565 <HTML><HEAD></HEAD><BODY><P>forgot to mention</P><P>I am trying to plot the monthly avg as a line graph and setting 25% monthly avg as a reference line threshold </P></BODY></HTML> Thu, 09 Mar 2017 11:00:48 GMT https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260698#M849565 dsharmaqv 2017-03-09T11:00:48Z Re: Avg By Month https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260699#M849566 <HTML><HEAD></HEAD><BODY><P>Count is a field? If it is, then may be this</P><P></P><P>Dimension</P><P><STRONG>Month</STRONG></P><P></P><P>Exp</P><P><STRONG>Avg(Count)</STRONG></P></BODY></HTML> Thu, 09 Mar 2017 11:00:49 GMT https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260699#M849566 sunny_talwar 2017-03-09T11:00:49Z Re: Avg By Month https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260700#M849567 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P></P><P> Use bar chart as</P><P></P><P>Dimension <STRONG>Month</STRONG></P><P></P><P>Measure <SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG> Avg(Count)</STRONG></SPAN></P><P></P><P></P><P>Set reference line..</P></BODY></HTML> Thu, 09 Mar 2017 11:23:45 GMT https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260700#M849567 hemachandran 2017-03-09T11:23:45Z Re: Avg By Month https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260701#M849568 <HTML><HEAD></HEAD><BODY><P>Hello Deepak,</P><P></P><P>Refer attached sample application.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 09 Mar 2017 11:58:10 GMT https://community.qlik.com/t5/QlikView/Avg-By-Month/m-p/1260701#M849568 rahulpawarb 2017-03-09T11:58:10Z