Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
autopilot
Contributor III

Re: sum of last 3 years avg, deliveries syntax

Try this....

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

1 Reply
autopilot
Contributor III

Re: sum of last 3 years avg, deliveries syntax

Try this....

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

Community Browser