https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1613081#M735823 <P>Hi,</P><P>&nbsp;</P><P>Try like this,</P><P>sum( {$&lt;Year={"$(=Max(Year))"},Date={"&lt;=$(=Date(Max(Date),'YYYY-MM-DD'))"}&gt;}SoldQty)</P> Fri, 16 Aug 2019 04:14:56 GMT devarasu07 2019-08-16T04:14:56Z https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1613060#M735822 <P>Hi All,</P><P>I know there's a ton of questions in regards to YTD Calculations, but I have a scenario where I have a list of Budgets for the entire year (January- December) and I am currently trying to put together an expression that captures the YTD Budget through Aug 2019 that would be dynamic to the year. So, if a user chose 2018, it would then display the YTD Budget through the year until they selected a specific month, then it would display the budget YTD through the chosen month.&nbsp;</P><P>I appreciate all of the help!</P><P>Best,</P><P>Rose</P> Sat, 16 Nov 2024 02:43:41 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1613060#M735822 rtr13 2024-11-16T02:43:41Z https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1613081#M735823 <P>Hi,</P><P>&nbsp;</P><P>Try like this,</P><P>sum( {$&lt;Year={"$(=Max(Year))"},Date={"&lt;=$(=Date(Max(Date),'YYYY-MM-DD'))"}&gt;}SoldQty)</P> Fri, 16 Aug 2019 04:14:56 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/1613081#M735823 devarasu07 2019-08-16T04:14:56Z