topic Re: YearToDate Calculation in QlikView https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378534#M141149 <HTML><HEAD></HEAD><BODY><P>for budget ytd paste the same exp as budget amount and check <STRONG>full acumulation</STRONG></P></BODY></HTML> Thu, 16 Aug 2012 13:38:25 GMT 2012-08-16T13:38:25Z YearToDate Calculation https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378533#M141148 <HTML><HEAD></HEAD><BODY><P>How to do a YTD calculation?</P><P></P><P>If you look at the table below, basically i have 3 fields, Period, BudgetAmount &amp; ActualAmount.</P><P></P><P>How to do an expression to calculate the yeartodate on budget and actual?</P><P><IMG __jive_id="20301" class="jive-image-thumbnail jive-image" height="169" onclick="" alt="Untitled.png" src="https://community.qlik.com/legacyfs/online/20301_Untitled.png" width="530" /></P></BODY></HTML> Thu, 16 Aug 2012 13:25:46 GMT https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378533#M141148 2012-08-16T13:25:46Z Re: YearToDate Calculation https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378534#M141149 <HTML><HEAD></HEAD><BODY><P>for budget ytd paste the same exp as budget amount and check <STRONG>full acumulation</STRONG></P></BODY></HTML> Thu, 16 Aug 2012 13:38:25 GMT https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378534#M141149 2012-08-16T13:38:25Z Re: YearToDate Calculation https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378535#M141150 <HTML><HEAD></HEAD><BODY><P>But its grey'd out?</P></BODY></HTML> Thu, 16 Aug 2012 13:43:44 GMT https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378535#M141150 2012-08-16T13:43:44Z Re: YearToDate Calculation https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378536#M141151 <HTML><HEAD></HEAD><BODY><P>send small sample app</P><P>i'll check</P></BODY></HTML> Thu, 16 Aug 2012 13:45:44 GMT https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378536#M141151 2012-08-16T13:45:44Z Re: YearToDate Calculation https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378537#M141152 <HTML><HEAD></HEAD><BODY><P>thanx just got it right, its in a pivot, ended using rangesum</P></BODY></HTML> Thu, 16 Aug 2012 14:19:24 GMT https://community.qlik.com/t5/QlikView/YearToDate-Calculation/m-p/378537#M141152 2012-08-16T14:19:24Z