sum last year

[Anonymous]

How can I calculate the sum of CA for all last year

sum((last year) ca ) ?

[gautik92]

Sum({<Year={$(=Max(Year)-1)}>}ca)

[qlikviewwizard · Accepted solution]

Sum({<Year={$(=YEAR(TODAY())-1)}>} CA)

[oleggggggM]

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!