Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum of last 3 years avg, deliveries syntax

Hi!

i would like to find the avg amount from the last three years based on the key figure Delivrery total.

my mission is to find out the average consumption per week of articles.

Pseudo Code: avg(year = 2011, 2012,2013)), TotalDelivery) / 53 ( amt of weeks in a year)

I was considering using set analysis , however once again my syntax fails me;

any help would be greatly appreciated;

Brad

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try this....

avg({<Year={2011,2012,2013}>} TotalDelivery) / 53

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Try this....

avg({<Year={2011,2012,2013}>} TotalDelivery) / 53