topic Re: YTD Calculation in QlikView https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1278670#M850895 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>Sum({&lt;CstFiscalPeriod = {'<SPAN style="color: #ff0000; font-size: 14pt;">&lt;=</SPAN>$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}&gt;} UnitActual)</STRONG></P></BODY></HTML> Mon, 13 Mar 2017 13:20:06 GMT sunny_talwar 2017-03-13T13:20:06Z YTD Calculation https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1278669#M850893 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have to show YTD Sale on the basis of selection.</P><P>If user Year = 2016 and Month = 5</P><P></P><P>YTD should show summation of Month = 1,2,3,4 and 5.</P><P>My expression is :</P><P></P><P>sum({&lt;CstFiscalPeriod &lt;= {'$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}&gt;} UnitActual)</P><P></P><P>But it is throwing error.</P><P>Please help.</P><P></P><P>Thanks,<BR />Sarif</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1278669#M850893 mhmmd_srf 2020-11-25T16:16:04Z Re: YTD Calculation https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1278670#M850895 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>Sum({&lt;CstFiscalPeriod = {'<SPAN style="color: #ff0000; font-size: 14pt;">&lt;=</SPAN>$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}&gt;} UnitActual)</STRONG></P></BODY></HTML> Mon, 13 Mar 2017 13:20:06 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1278670#M850895 sunny_talwar 2017-03-13T13:20:06Z