Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare this year sales to last year

hi,

how to get and compare particular two years sales of customers.

how to add a field which contains the past year and present year netsales.

1 Reply
Not applicable
Author

Use Set Analysis someting like for this year

Sum({1 <Year=Year(today())>},Sales)

and for last year

Sum({1} <Year = Year(today())-1},Sales)