topic Re: sum last year in QlikView https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957224#M967772 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Year={$(=Max(Year)-1)}&gt;}ca)</P></BODY></HTML> Tue, 29 Sep 2015 10:19:15 GMT gautik92 2015-09-29T10:19:15Z sum last year https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957223#M967771 <HTML><HEAD></HEAD><BODY><P>How can I calculate the sum of CA for all last year </P><P></P><P>sum((last year) ca ) ?</P></BODY></HTML> Tue, 29 Sep 2015 10:16:27 GMT https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957223#M967771 Anonymous 2015-09-29T10:16:27Z Re: sum last year https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957224#M967772 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Year={$(=Max(Year)-1)}&gt;}ca)</P></BODY></HTML> Tue, 29 Sep 2015 10:19:15 GMT https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957224#M967772 gautik92 2015-09-29T10:19:15Z Re: sum last year https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957225#M967773 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Sum({&lt;Year={$(=YEAR(TODAY())-1)}&gt;} CA)</SPAN></P></BODY></HTML> Tue, 29 Sep 2015 10:33:15 GMT https://community.qlik.com/t5/QlikView/sum-last-year/m-p/957225#M967773 qlikviewwizard 2015-09-29T10:33:15Z Re: sum last year https://community.qlik.com/t5/QlikView/sum-last-year/m-p/1855513#M1215856 <P>How do you calculate the SUM for ALL previous years? If the user selects the Year 2021, he will see two KPIs: (1) TOtal sales for 2021; (2) Total sales for all previous years (2015-2021)? thank you!</P> Thu, 04 Nov 2021 12:31:33 GMT https://community.qlik.com/t5/QlikView/sum-last-year/m-p/1855513#M1215856 oleggggggM 2021-11-04T12:31:33Z