topic Re: Group by Month in QlikView https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058172#M354595 <HTML><HEAD></HEAD><BODY><P>Do you mean Sum(Revenue)/Count(Client)&nbsp; or Sum(Client)</P><P></P><P>How would you calculate Sum(Client) here?</P></BODY></HTML> Mon, 02 May 2016 19:52:00 GMT sunny_talwar 2016-05-02T19:52:00Z Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058171#M354594 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have a data containing</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"><STRONG>Month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Revenue</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Client</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2010</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">13</TD><TD style="padding: 2px;">B</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2010</TD><TD style="padding: 2px;">14</TD><TD style="padding: 2px;">B</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">B</TD></TR></TBODY></TABLE><P></P><P></P><P>And I want a chart like this:</P><P></P><P>YValue =&nbsp; Sum(Revenue) / Sum(Client)</P><P>XValue = Month of the Year</P><P></P><P>How can I by Month number ?</P></BODY></HTML> Mon, 02 May 2016 19:44:24 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058171#M354594 2016-05-02T19:44:24Z Re: Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058172#M354595 <HTML><HEAD></HEAD><BODY><P>Do you mean Sum(Revenue)/Count(Client)&nbsp; or Sum(Client)</P><P></P><P>How would you calculate Sum(Client) here?</P></BODY></HTML> Mon, 02 May 2016 19:52:00 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058172#M354595 sunny_talwar 2016-05-02T19:52:00Z Re: Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058173#M354596 <HTML><HEAD></HEAD><BODY><P>Sorry, ..&nbsp;&nbsp;&nbsp; I mean <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(Revenue)/Count(Client) , grouped by Month independently of the year</SPAN></P></BODY></HTML> Mon, 02 May 2016 19:57:09 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058173#M354596 2016-05-02T19:57:09Z Re: Group by Month https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058174#M354597 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123315_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 02 May 2016 20:24:28 GMT https://community.qlik.com/t5/QlikView/Group-by-Month/m-p/1058174#M354597 sunny_talwar 2016-05-02T20:24:28Z