Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Facundo
Contributor II
Contributor II

Last Year Sales with Year as Dimension

Hi, I need to show Last Year Sales per Year, but I'm always end with the same result :

 

1.PNG

And I need this :

2.PNG

 

Sales :  Sum(Sales)

LY Sales :  Sum({<Year={"$(=Date(Year-1,'YYYY'))"}>} Sales)

 

Thanks for any advice.

Labels (2)
20 Replies
Facundo
Contributor II
Contributor II
Author

I figured, thanks for the answers, I will mark them as correct since they work in other versions.