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

juraj_misina
Luminary Alumni
Luminary Alumni
‎2018-10-16 09:48 AM

In response to ronman10

OK, so the dimension is not [Year], but [Date.autoCalendar.Year], which means the expression should be:

Sum([Volume])/Sum(TOTAL <Date.autoCalendar.Year> [Volume])


EDIT: I also changed [Sales Volume] to [Volume] according the screenshot.

View solution in original post

1 user say ditto
3,019 Views
Who Me Too'd this solution