topic YTD calculation in QlikView https://community.qlik.com/t5/QlikView/YTD-calculation/m-p/809473#M285705 <HTML><HEAD></HEAD><BODY><P>i have the following code to calculate amount </P><P></P><P>=IF( ValueLoop(1,12,1)=1 ,num(sum({$&lt;Network={1},Src={1},BillMonthNo={'&lt;=$(vBillMonthNo)'} &gt;}Amount),'R # ##0,00')....</P><P></P><P>this code works wneh nothing on BillMonth is selected therefore vBillMonthNo=12 so everything is calculated </P><P>but wen i select a month say Nov my vBillMonthNo becomes 11 but now it only calculates for one month </P><P>please assit </P></BODY></HTML> Mon, 19 Jan 2015 08:09:17 GMT Anonymous 2015-01-19T08:09:17Z YTD calculation https://community.qlik.com/t5/QlikView/YTD-calculation/m-p/809473#M285705 <HTML><HEAD></HEAD><BODY><P>i have the following code to calculate amount </P><P></P><P>=IF( ValueLoop(1,12,1)=1 ,num(sum({$&lt;Network={1},Src={1},BillMonthNo={'&lt;=$(vBillMonthNo)'} &gt;}Amount),'R # ##0,00')....</P><P></P><P>this code works wneh nothing on BillMonth is selected therefore vBillMonthNo=12 so everything is calculated </P><P>but wen i select a month say Nov my vBillMonthNo becomes 11 but now it only calculates for one month </P><P>please assit </P></BODY></HTML> Mon, 19 Jan 2015 08:09:17 GMT https://community.qlik.com/t5/QlikView/YTD-calculation/m-p/809473#M285705 Anonymous 2015-01-19T08:09:17Z