topic How to accumulate yearly sum amount in QlikView https://community.qlik.com/t5/QlikView/How-to-accumulate-yearly-sum-amount/m-p/244140#M93141 <HTML><HEAD></HEAD><BODY><P>Can't you just add the Year dimension to the table to show the sum/count ect. of the data? Then just put </P><P></P><P>if(Year=Year(today()), 0 , sum(field))</P></BODY></HTML> Mon, 21 Nov 2011 15:24:52 GMT 2011-11-21T15:24:52Z How to accumulate yearly sum amount https://community.qlik.com/t5/QlikView/How-to-accumulate-yearly-sum-amount/m-p/244139#M93140 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I'd like to know how to calculate accumated data (e.g. total yearly sum amount) in a pivot table.</P><P>Which function should I use?</P><P></P><P>And plus, if the data doesn't reach till the end of the year, accumulated yearly sum amount is not allowed to show in the table.</P><P></P><P>Looking forward to your help.</P><P></P><P>Thank you!!</P></BODY></HTML> Mon, 21 Nov 2011 15:22:27 GMT https://community.qlik.com/t5/QlikView/How-to-accumulate-yearly-sum-amount/m-p/244139#M93140 2011-11-21T15:22:27Z How to accumulate yearly sum amount https://community.qlik.com/t5/QlikView/How-to-accumulate-yearly-sum-amount/m-p/244140#M93141 <HTML><HEAD></HEAD><BODY><P>Can't you just add the Year dimension to the table to show the sum/count ect. of the data? Then just put </P><P></P><P>if(Year=Year(today()), 0 , sum(field))</P></BODY></HTML> Mon, 21 Nov 2011 15:24:52 GMT https://community.qlik.com/t5/QlikView/How-to-accumulate-yearly-sum-amount/m-p/244140#M93141 2011-11-21T15:24:52Z