topic YTD BUDGET calculation in QlikView https://community.qlik.com/t5/QlikView/YTD-BUDGET-calculation/m-p/597758#M221348 <HTML><HEAD></HEAD><BODY><P>Hi i have the following keys attaching budget to Sales - YearMonth</P><P>i have also budget year and month as dimensions on the budgettable.</P><P></P><P>i wish to create a YTD calculation for Budget but however have not been able to get it right.</P><P></P><P>see calculation below;</P><P></P><P>=SUM({&lt;BudgetYear={'$(vMaxBudgetYear)'},Date2={'&lt;=$(vMaxDate)'},Month=,Day=,[BudgetYearMonth]=&gt;}BudgetSEK)</P><P></P><P>i have attached my document for further reference.</P><P></P><P>Budget value should be 23 M , not 84 (total).</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Wed, 19 Mar 2014 22:00:57 GMT 2014-03-19T22:00:57Z YTD BUDGET calculation https://community.qlik.com/t5/QlikView/YTD-BUDGET-calculation/m-p/597758#M221348 <HTML><HEAD></HEAD><BODY><P>Hi i have the following keys attaching budget to Sales - YearMonth</P><P>i have also budget year and month as dimensions on the budgettable.</P><P></P><P>i wish to create a YTD calculation for Budget but however have not been able to get it right.</P><P></P><P>see calculation below;</P><P></P><P>=SUM({&lt;BudgetYear={'$(vMaxBudgetYear)'},Date2={'&lt;=$(vMaxDate)'},Month=,Day=,[BudgetYearMonth]=&gt;}BudgetSEK)</P><P></P><P>i have attached my document for further reference.</P><P></P><P>Budget value should be 23 M , not 84 (total).</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Wed, 19 Mar 2014 22:00:57 GMT https://community.qlik.com/t5/QlikView/YTD-BUDGET-calculation/m-p/597758#M221348 2014-03-19T22:00:57Z