topic Re: Total Profit by Year in QlikView https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779335#M276228 <HTML><HEAD></HEAD><BODY><P>Aaron,</P><P></P><P>The solution you provided worked perfectly.&nbsp; Thanks so much for your help!</P></BODY></HTML> Tue, 24 Mar 2015 14:53:01 GMT mphekin12 2015-03-24T14:53:01Z Total Profit by Year https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779332#M276225 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to get a figure out how to create the column 'Total Profit by Year' in QlikView.&nbsp; Can someone please explain how it can be done?</P><P></P><P>Thank you!<IMG alt="ProfitByYear.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81697_ProfitByYear.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 24 Mar 2015 13:57:39 GMT https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779332#M276225 mphekin12 2015-03-24T13:57:39Z Re: Total Profit by Year https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779333#M276226 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use this expression.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">rangesum</SPAN>(above( sum( field name ), 12 ))</SPAN></P></BODY></HTML> Tue, 24 Mar 2015 14:13:30 GMT https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779333#M276226 2015-03-24T14:13:30Z Re: Total Profit by Year https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779334#M276227 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 10pt;">RangeSum</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">Above</SPAN>(<SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #800000;">Profit</SPAN>), 0, <SPAN style="color: #0000ff;">Num</SPAN>(<SPAN style="color: #800000;">Month</SPAN>))) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Assuming your field is called Profit and your Month-Year has been created from a master calendar including Month and Year...alternatively use the Num(Month(MonthYear)) if not..</SPAN></P></BODY></HTML> Tue, 24 Mar 2015 14:21:16 GMT https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779334#M276227 morganaaron 2015-03-24T14:21:16Z Re: Total Profit by Year https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779335#M276228 <HTML><HEAD></HEAD><BODY><P>Aaron,</P><P></P><P>The solution you provided worked perfectly.&nbsp; Thanks so much for your help!</P></BODY></HTML> Tue, 24 Mar 2015 14:53:01 GMT https://community.qlik.com/t5/QlikView/Total-Profit-by-Year/m-p/779335#M276228 mphekin12 2015-03-24T14:53:01Z