Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this solution

anat
Master
Master
‎2024-01-19 08:27 PM

Previous year:

Sum({<[OrderDate.autoCalendar.Year] = {"$(=Max(Year(OrderDate)) - 1)"}>} Sales)

Current year:

Sum({<[OrderDate.autoCalendar.Year] = {"$(=Max(Year(OrderDate)))"}>} Sales)

 

It will be based on your selection to get what is the lastest(max) possible year, and minor 1 to get its previous year.

View solution in original post

1 user say ditto
473 Views
Who Me Too'd this solution