Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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