topic How to sum value to the same month by years? in App Development https://community.qlik.com/t5/App-Development/How-to-sum-value-to-the-same-month-by-years/m-p/1345922#M29801 <HTML><HEAD></HEAD><BODY><P>Hello, Everyone.</P><P></P><P>Currently, I get a question in app development of Qlik Sense.</P><P>Please read the example below.</P><P></P><P>I get source data as below (actually there are many record in each month)</P><TABLE border="1" class="jiveBorder" height="424" style="border: 1px solid rgb(0, 0, 0); width: 235px; height: 409px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date ( YYYY-MM-DD )</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">2013-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-02-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-03-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-04-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-05-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-06-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-07-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-08-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-09-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-10-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-11-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-12-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-02-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-03-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-04-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>What I want to do is to get the sum from beginning to the same month in different years as below.</P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 706px; height: 100px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dimension ( YYYY-MM )</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;" valign="middle">Measure</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;" valign="middle"><P>Comment</P></TH></TR><TR><TD style="padding: 2px;">2013-03</TD><TD style="padding: 2px; color: #000000; text-align: left;">3</TD><TD style="padding: 2px; color: #000000; text-align: left;">sum from 2013-01-01 to 2013-03-01</TD></TR><TR><TD style="padding: 2px;">2014-03</TD><TD style="padding: 2px; color: #000000; text-align: left;">15</TD><TD style="padding: 2px; color: #000000; text-align: left;"><SPAN style="color: #000000; font-size: 13.3333px;">sum from 2013-01-01 to 2014-03-01</SPAN></TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px; color: #000000; text-align: left;"></TD><TD style="padding: 2px; color: #000000; text-align: left;"></TD></TR></TBODY></TABLE><P></P><P>I meet this requirement for the 1st time. So can anyone help me?</P><P>thank you very much.</P><P></P><P>Larry</P></BODY></HTML> Fri, 23 Jun 2017 02:05:44 GMT Anonymous 2017-06-23T02:05:44Z How to sum value to the same month by years? https://community.qlik.com/t5/App-Development/How-to-sum-value-to-the-same-month-by-years/m-p/1345922#M29801 <HTML><HEAD></HEAD><BODY><P>Hello, Everyone.</P><P></P><P>Currently, I get a question in app development of Qlik Sense.</P><P>Please read the example below.</P><P></P><P>I get source data as below (actually there are many record in each month)</P><TABLE border="1" class="jiveBorder" height="424" style="border: 1px solid rgb(0, 0, 0); width: 235px; height: 409px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date ( YYYY-MM-DD )</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">2013-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-02-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-03-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-04-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-05-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-06-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-07-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-08-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-09-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-10-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-11-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2013-12-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-01-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-02-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-03-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2014-04-01</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>What I want to do is to get the sum from beginning to the same month in different years as below.</P><TABLE border="1" class="jiveBorder" height="99" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 706px; height: 100px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dimension ( YYYY-MM )</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;" valign="middle">Measure</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px; font-family: arial, helvetica, sans-serif; vertical-align: baseline;" valign="middle"><P>Comment</P></TH></TR><TR><TD style="padding: 2px;">2013-03</TD><TD style="padding: 2px; color: #000000; text-align: left;">3</TD><TD style="padding: 2px; color: #000000; text-align: left;">sum from 2013-01-01 to 2013-03-01</TD></TR><TR><TD style="padding: 2px;">2014-03</TD><TD style="padding: 2px; color: #000000; text-align: left;">15</TD><TD style="padding: 2px; color: #000000; text-align: left;"><SPAN style="color: #000000; font-size: 13.3333px;">sum from 2013-01-01 to 2014-03-01</SPAN></TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px; color: #000000; text-align: left;"></TD><TD style="padding: 2px; color: #000000; text-align: left;"></TD></TR></TBODY></TABLE><P></P><P>I meet this requirement for the 1st time. So can anyone help me?</P><P>thank you very much.</P><P></P><P>Larry</P></BODY></HTML> Fri, 23 Jun 2017 02:05:44 GMT https://community.qlik.com/t5/App-Development/How-to-sum-value-to-the-same-month-by-years/m-p/1345922#M29801 Anonymous 2017-06-23T02:05:44Z