article YTD Calculation by Month in Qlik Learning Documents https://community.qlik.com/t5/Qlik-Learning-Documents/YTD-Calculation-by-Month/ta-p/1489886 <HTML><HEAD></HEAD><BODY><P>Calculated YTD using the selected Month with a Graph comparing the Month by Account to the YTD Sales value.</P></BODY></HTML> Thu, 06 Nov 2014 05:53:38 GMT djsampat 2014-11-06T05:53:38Z YTD Calculation by Month https://community.qlik.com/t5/Qlik-Learning-Documents/YTD-Calculation-by-Month/ta-p/1489886 <HTML><HEAD></HEAD><BODY><P>Calculated YTD using the selected Month with a Graph comparing the Month by Account to the YTD Sales value.</P></BODY></HTML> Thu, 06 Nov 2014 05:53:38 GMT https://community.qlik.com/t5/Qlik-Learning-Documents/YTD-Calculation-by-Month/ta-p/1489886 djsampat 2014-11-06T05:53:38Z Re: YTD Calculation by Month https://community.qlik.com/t5/Qlik-Learning-Documents/YTD-Calculation-by-Month/tac-p/1489887#M137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Best to use set analysis for better performance and change the expression to</P><P></P><P><SPAN style="font-size: 8pt;">= </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({1 &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthId</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(vMonthId)"</SPAN><SPAN style="font-size: 8pt;">}&gt; }</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>Cheers</P></BODY></HTML> Thu, 08 Jan 2015 11:33:25 GMT https://community.qlik.com/t5/Qlik-Learning-Documents/YTD-Calculation-by-Month/tac-p/1489887#M137 richard_pearce6 2015-01-08T11:33:25Z