Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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