Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
madushanfernand
Contributor III
Contributor III

previous year counts when using cannonical dates

Hi All

could some one please tell how to get the sum of for the previous year sales, quantity etc if we have past records for last years as per the given popular example of using canonical date.

Capture.PNG

Thank you

Madushan

1 Reply
Gysbert_Wassenaar

sum({<Year={$(=Year(Today())-1)}>}sales)


talk is cheap, supply exceeds demand