topic Re: custom sum in QlikView https://community.qlik.com/t5/QlikView/custom-sum/m-p/693689#M250886 <HTML><HEAD></HEAD><BODY><P>found <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>if(Date=max(ALL Date), sum(TOTAL&nbsp; Amount2)</P></BODY></HTML> Fri, 24 Oct 2014 15:19:11 GMT 2014-10-24T15:19:11Z custom sum https://community.qlik.com/t5/QlikView/custom-sum/m-p/693688#M250885 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have data like the following : </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>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount2</STRONG></TH></TR><TR><TD style="padding: 2px;">Jan. 2014</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">Feb. 2014</TD><TD style="padding: 2px;">150</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD style="padding: 2px;">Mars 2014</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">5000</TD></TR><TR><TD style="padding: 2px;">Apr. 2014</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">3000</TD></TR></TBODY></TABLE><P></P><P>I need to create a table where Amount2 of the last month = sum(Amount2) of all the months :</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>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">Jan. 2014</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">Feb. 2014</TD><TD style="padding: 2px;">150</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">Mars 2014</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">Apr. 2014</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">10000</TD></TR></TBODY></TABLE><P></P><P>Regards</P></BODY></HTML> Fri, 24 Oct 2014 15:09:11 GMT https://community.qlik.com/t5/QlikView/custom-sum/m-p/693688#M250885 2014-10-24T15:09:11Z Re: custom sum https://community.qlik.com/t5/QlikView/custom-sum/m-p/693689#M250886 <HTML><HEAD></HEAD><BODY><P>found <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>if(Date=max(ALL Date), sum(TOTAL&nbsp; Amount2)</P></BODY></HTML> Fri, 24 Oct 2014 15:19:11 GMT https://community.qlik.com/t5/QlikView/custom-sum/m-p/693689#M250886 2014-10-24T15:19:11Z